Let's go step by step.
Open your mailmerge main document.
Use Alt-F9 to show the field codes, so they look something like
{ MERGEFIELD DateOfBirth stuff }
Do you see the fields looking like that? If not, then maybe Alt-F9 is
not working as expected.
If you do, what is actually in the field? i.e. what do you have where I
have stuff ?
Whatever it is, try changing stuff to be what Graham suggested, which is
\@ "MMMM d, yyyy"
then preview you merge data or remerge to a new document. That should at
least give you a date in a format like
January 10, 2009
If it actually gives you
October 1, 2009
for a date that should be January 10, then you will need to create a
query to fix the date format. Precisely how to do that depends on
whether you are in a position to modify the access database and so on.
But let's see if that is necessary first.
That may give you some clues as to what to do about the SIN and Vac%
fields. However, in the case of the Vac% field, you will definitely need
to multiply your number by 100 to get the % in Word. You can do that
using a nested field, e.g.
{ ={ MERGEFIELD "Vac%" }*100 \#0% }
You can create a field like this by using ctrl-F9 to insert each pair of
the special field code braces {}, and typing everything else in the
normal way. You may need to use Alt-F9 to show the field codes again if
they disappear.
Peter Jamieson
http://tips.pjmsn.me.uk
Pat wrote:
Thank you for your help.
You are correct the DDE method did not work.
I tried Graham's other suggestion but I do not think I am applying it
correctly.
You asked for more specifics in order to instruct me properly so here goes:
My database table is already formatted as follows:
Field: SIN set as Text with Input Mask 999\ 999\ 999
Field: DateofBirth: set as Date/Time, long date, format: mmmm dd "," yyyy
Field: Vac% set as Number, format: percentage
When I create the merge into my word document the corresponding results a
Field: SIN 493666789 (no spaces) should be: 493 666 789
Field: DateofBirth: 1970/12/27 should be: December 27, 1970
Field: Vac% 8.00000000002E-2 should be: 8%
I am merging approx. 200 records. These are just a few of the
inconsistencies, once I understand how to fix them I should be able to
correct the rest on my own.