Word mail merge from Access - keeping the zeros in numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KingTrog - 12 Jun 2006 19:03 GMT

I am using mail merge in word to collect data from Access but ID numbers such
as 0002 lose the zeros, and in dates 01/01/2006 become 1/1/2006 - how do I
stop this happening.

Reply to this Message

Doug Robbins - Word MVP - 13 Jun 2006 04:45 GMT

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

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am using mail merge in word to collect data from Access but ID numbers
>such
> as 0002 lose the zeros, and in dates 01/01/2006 become 1/1/2006 - how do I
> stop this happening.

Reply to this Message