Mail merge word-access and date format

  • Thread starter Thread starter lafayette
  • Start date Start date
L

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
 
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?
 
Back
Top