mailmerge from Access to Word

[Giles Ayling]

I am loosing the currency format when I mailmereg from Access 2007 to Word
2007. Anything I can do?

 

[Peter Jamieson]

Generally speaking if your format is always the same, it is better to format
the number in Word.

e.g. if your field is called myamount, and you want it to appear as
$9,123.00,
a. use Alt-F9 to show the field codes in your Word mail merge main
document. You should see something like

{ MERGEFIELD myamount }

If you see an additional "switch" saying \*Mergeformat, you can usually
delete it.

Then add a "numeric format switch" to the field so it looks like

{ MERGEFIELD myamount \*"$,0.00" }

NB, that should work even for larger amounts, i.e. the "," means "use a
thousands separator"

If you have other regional settings, e.g. you need £, or "." is set up as
the thousands separator in Control Panel->Regional Settings, use those.

Alternatively, you can usually see the formatting that you defined in Access
by changing the way that Word connects to Access to use the old DDE method.
However, I would avoid that unless it's really necessary.

 

[Jame]

You need to change your Word options. If you are using 2003 or earlier,
choose Tools- Options. If you are using 207, choose the Office Icon and then
Word Options. You will need to choose an option called "Confirm Conversion