From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button Word Options Advanced General Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.
OR
You will need some switches on your merge fields. Toggle the display ALT+F9
from fieldname to {Mergefield Fieldname}
{Mergefield Vacation \# "0%" }
{Mergefield DOB \@ "MMMM d, yyyy"}
{Mergefield SIN \# "000 000 000"}
http://www.gmayor.com/formatting_word_fields.htm
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Pat wrote:
I would love it if this merge works.
I have an employee database in Access with dates and percentages etc.
I have a document created in word.
When I merge to the word document the following happens (these are
only some of the challenges but if I can fix them I will understand
how to fix any others):
In database Vacation is set at 6% in the merge document it shows:
5.99999992-E
In database Date of Birth is: December 10, 2007 in the merge it shows
either 12/10/2007 or 12:10:2007:0000
In the database SIN is: 999 999 999 in the merge it shows as:
999999999