[macropod[_2_]]

Hi Pat,

Try adding switches to your mergefields as follows:
{MERGEFIELD SIN \# "000' '000' '000"}
{MERGEFIELD DateofBirth \@ "MMMM DD, YYYY"}
{MERGEFIELD Vac% \# 0%}

--
Cheers
macropod
[Microsoft MVP - Word]


"Pat" wrote in message ...
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.
--
Thanks, Pat
email:


"Peter Jamieson" wrote:

I do not get a message when I attach the data source asking
if I want to use the DDE method of connection (or any message at all
for that matter).

Typically, after you select your data source in the Select Data Source
dialog box, you then click the Open button.

If you checked the option that Graham mentioned, after you click Open,
you should see an additional dialog box titled "Confirm Source" This
lists the various possible ways that Word thinks you can use to open tat
data source. If the data source is an Access .mdb file, you will
normally see a DDE option (something like "MS Access Databases via DDE
(*.mdb,*.mde). However, if the database is an Access 2007 .accdb file,
you will not see that option unless you /also/ check "Show All." If that
isn't what you see, it's helpful if you can spell out what you do see.

Also, you may find that DDE does not work very well in Office 2007, so
the other approach Graham mentioned is usually to be preferred. But
again, it would probably help if you can spell out what went wrong, or
did not happen.


Peter Jamieson

http://tips.pjmsn.me.uk

Pat wrote:
Well the first portion of the instructions worked!!
I do not get a message when I attach the data source asking if I want to use
the DDE method of connection (or any message at all for that matter).

I then went to your 2nd suggestion which did not improve the appearance of
the data.