Mail merge word-access and date format

[lafayette]

Hi all, I found only an old post about this topic, dated 2003 and
without replies...I hope to have more luck. Here we go with the
problem:

I'm using the microsoft-created procedure to mail merge with VBA code,
the code is pretty straightforward and works perfectly, the only
problem is about dates format: in my db are stored in the format dd/mm/
yyyy, while when merged to word document they get in US format (mm/dd/
yyyy).

I only found options in word to format date fields that are "produced"
by word itself and not read from the query, so I'm getting a little
stuck. Would be good to convert in text those dates? And if yes, how?

thanks

 

[Peter Hibbs]

You can use the MergeField facility in Word to format a date field in
whatever way you want. See this site for more info :-
http://word.mvps.org/FAQs/MailMerge/index.htm

HTH

Peter Hibbs.

 

[lafayette]

That's a HUGE and unvaluable hint. Great faq pages.
thank you

 

[lafayette]

Following this code instructions (http://support.microsoft.com/kb/
209976/en-us), I have a little problem:

the whole procedure opens me both files, the master one with
mergefields and the second one merged. Would be possible to have
opened only the second one merged, and leave the master in safe,
closed and read only?