Merging to a Word Document

[Sandra]

Another question for you.

When I am merging from Access 2000 to Word 2002, the 200
records contains numerical figures. In access the format
for the numbers is how I want it to be i.e. 100,000, but
when I do the merge into word it appears at 100000.
Missing commas. Also if there is no figure in the access
field it shows up in word as a 0. I want the field to
remain empty rather than have a 0.

 

[Doug Robbins - Word MVP]

Hi Sandra,

You can either do this in Access by using a query as the data source and use
an

IIF(Number > 0, Format(Number, "#,##0"), "")

expression in the query.

Or use an If..Then..Else field in the mailmerge maindocument and use a \#
"#,##0" formatting switch inside the closing } of the merge field.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP