Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IMPORTING ACCESS INTO WORD MERGE
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data from Access to Word | Microsoft Word Help | |||
Importing single values from an Access database into a Word docume | Microsoft Word Help | |||
Importing data from a database (Excel or Access) into Word documen | Microsoft Word Help | |||
Importing data From Word Form to Access | Microsoft Word Help | |||
importing access database | Microsoft Word Help |