View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default IMPORTING ACCESS INTO WORD MERGE

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