Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge - Number Format vs 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! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge - Number Format vs Text
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" wrote in message ... 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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Number format | Mailmerge | |||
Email Merge but lost of format | New Users | |||
How do I email and HTML format mail merge? | Mailmerge | |||
EMail Merge HTML Format | Mailmerge | |||
Email format in Mail Merge | Mailmerge |