Maintaining Data Formats in MAIL MERGE

[Anny]

Hi,

I was trying to use the mail merge function for drafting
letters. I am using an excel spreadsheet as a data source
for this merge. However, when I perform mail merge, the
formatting of currency and numbers do not appear as it
does in the spreadsheet.

For example,
$26,000.00 would appear in the merged document as $26000

and numbers like 26,000 would appear as 26000

I need to retain the original formatting or else I would
have to edit each page manually. Can someone please help
me? Thanks in advance.

-Anny

 

[Cindy M -WordMVP-]

Hi Anny,

May we assume this is Word 2002 or 2003? See the Word 2002
section in my website's mail merge FAQ, plus the information
on formatting. To summarize: you can either change the way
you link to the Excel data, or add numeric formatting
switches to the merge fields.

I was trying to use the mail merge function for drafting
letters. I am using an excel spreadsheet as a data source
for this merge. However, when I perform mail merge, the
formatting of currency and numbers do not appear as it
does in the spreadsheet.

For example,
$26,000.00 would appear in the merged document as $26000

and numbers like 26,000 would appear as 26000

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail