It sounds as if you've probably upgraded from Word 97 or 2000.
In Word 2007 you need to switch back to the DDE connection method - check
Microsoft
Office Button|Word Options|Advanced|General|"Confirm File format conversion
upon open" then go through the process of opening your data source again.
If you have non-ANSI Unicode characters in your data, DDE won't return them.
Also, no method currently lets you use more than 255 columns in an Excel
sheet, and with DDE the number may be more restricted in Word 2007.
Peter Jamieson
"Mensa Level" <MensaLevel[ at ]discussions.microsoft.com> wrote in message
news:1D35AFEB-9733-4627-8B0E-9D701B8FFAF3[ at ]microsoft.com...
[Quoted Text] > It seems to me that in previous versions of office - if I pasted special
> values into my Excel merge data base it would flow through to the email
> merge
> - now I have to tediously type in $ and commas in text formatting in order
> to
> get the numbers to flow through properly. Otherwise it would just be
> 155553823.35
> Does anyone know a better way?? I still want the commas represented in the
> emails. Thanks!
|