IMPORTING ACCESS INTO WORD MERGE

P

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.
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top