Email Merge - Number Format vs Text

[Mensa Level]

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!

 

[Peter Jamieson]

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