A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Merging from Access



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2010, 04:45 PM posted to microsoft.public.word.mailmerge.fields
Andrew B
external usenet poster
 
Posts: 14
Default Merging from Access

Hi

I am trying to merge information from an access db into a word document and
have two annoying things which happen.

1. The server system (2003), Access and Word are all set for English UK
language and UK regional settings, however when data is merged dates come out
in US format and formatting is not preserved (although selected).

2. several of the merged fields are calculated dates which appear fine in
the database form but are blank on the merged document.

The information is for Wedding Banns so the format is a set legal
requirement and can't be changed

anyone have any suggestions how to solve this?

Andrew B
--
I used to have hair!
  #2  
Old March 19th, 2010, 08:09 PM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Merging from Access

Hi Andrew,

To get the date format you want, you can add a formatting picture switch. In Word:
.. select the mergefield;
.. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where 'MyDate' is your mergefield's
name;
.. delete anything appearing after the mergefield's name and add '\@ "d MMMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "d MMMM
yyyy"}. With this switch your date will come out as '2 August 2008'. Other possible date formatting switches include:
. \@ "dddd, d MMMM yyyy";
. \@ "ddd, d MMMM yyyy";
. \@ "d MMM yyyy";
. \@ "dd/MMM/yyyy";
. \@ "d-MM-yy";
Note: Note: you can swap the d, M, y expressions around, but you must use uppercase 'M's for months.
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.


As for (2), does this affect all the calculated fields, or only some? Are the calculated dates a consistent offset from other date
constants that are available to the mailmerge? If so, you may be able to solve the issue by having Word do the calculations. To see
how to do this and just about everything else you might want to do with dates in Word, check out my Word Date Calculation Tutorial,
at:
http://lounge.windowssecrets.com/ind...owtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Date and Time Calculations In A Mailmerge'. Do read the document's introductory material.


--
Cheers
macropod
[Microsoft MVP - Word]


"Andrew B" wrote in message ...
Hi

I am trying to merge information from an access db into a word document and
have two annoying things which happen.

1. The server system (2003), Access and Word are all set for English UK
language and UK regional settings, however when data is merged dates come out
in US format and formatting is not preserved (although selected).

2. several of the merged fields are calculated dates which appear fine in
the database form but are blank on the merged document.

The information is for Wedding Banns so the format is a set legal
requirement and can't be changed

anyone have any suggestions how to solve this?

Andrew B
--
I used to have hair!


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.