mail merge recipients table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sueP - 10 Jun 2004 12:43 GMT

When I merge a word document with an Access database I
find that the formatting of numeric fields is incorrect.
The original table is formatted to 2 decimal places but
in the Mail Merge Recipients window and in the merged
document the decimal places are numerous. Also there are
fields which include calculations in the original table
but the calculated data does not appear in the Mail Merge
recipients window nor in the merged document. Can anyone
help?

Reply to this Message

Doug Robbins - Word MVP - 11 Jun 2004 09:51 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

For the calculation problem, you may be able to do the calculation in word
by putting the base mergefields inside an { = } field construction in the
mailmerge main document.

Alternatively, if you check the "Confirm conversions at Open" box under
Tools> Options>General and change the connection method, the calculated data
may appear.

Signature

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

> When I merge a word document with an Access database I
> find that the formatting of numeric fields is incorrect.
[quoted text clipped - 5 lines]
> recipients window nor in the merged document. Can anyone
> help?

Reply to this Message