[Pat]

I know I have asked this before but I cannot get it to work.
I have a document in word 2002 which I would like to create for each of our
200 employees. I would like the data from my access database exported into
this word document (fields like name, address, phone number, date of birth,
S.I.N. number, salary information dependent information etc etc). When I
attempted this merge the information was correct but the formatting was all
wrong. Example: Birthdate appears as 21:12:00 rather than December 21,
2000. SIN appears as 999999999 rather than 999 999 999, perecentage appears
as .00000000000000000000006 rather than 6%. I lost capitals in names.

I am sure you get the idea!!

How can I get the information from Access to my Word document while
maintaining the correct formatting of the fields.
--
Thanks, Pat

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm


--
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, originally posted via msnews.microsoft.com
"Pat" wrote in message
...
I know I have asked this before but I cannot get it to work.
I have a document in word 2002 which I would like to create for each of
our
200 employees. I would like the data from my access database exported
into
this word document (fields like name, address, phone number, date of
birth,
S.I.N. number, salary information dependent information etc etc). When I
attempted this merge the information was correct but the formatting was
all
wrong. Example: Birthdate appears as 21:12:00 rather than December 21,
2000. SIN appears as 999999999 rather than 999 999 999, perecentage
appears
as .00000000000000000000006 rather than 6%. I lost capitals in names.

I am sure you get the idea!!

How can I get the information from Access to my Word document while
maintaining the correct formatting of the fields.
--
Thanks, Pat