Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
sam
 
Posts: n/a
Default Wrong mail merge date format

I have an access database set up with several letters merged to the data
contained in a table. The date format in the table is short date dd/mm/yy. In
the word document I have {MERGEFIELD StartDate \@"dd/MM/yy"} and {MERGEFIELD
EndDate \@"dd/MM/yy"}
The end date looks correct as dd/MM/yy but the start date appears as
MM/dd/yy even though the switch is as dd/MM/yy. I just can's get it to go to
the corect format. Any ideas?

One other problem I have is a date at the top of the letter which I want to
change to today's date as it is opened. On some letters it works fine and on
others it shows the wrong date (the date it was last updated to). I have
checked the 'update automatically' box but it doesn't seem to work on all
letters.... any help with this appreciated too

--
Thanks
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge date format problem with Word 2003 Thang New Users 1 May 2nd 05 01:55 PM
Mail merge date format changes to numerical using Windows XP Busi. Lynsoo Mailmerge 3 April 16th 05 02:28 PM
incorrect date format in mail merge mark P Mailmerge 1 December 14th 04 08:29 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM
Why does the date format change when I mail merge from Access? Alex Mailmerge 1 December 6th 04 02:25 PM


All times are GMT +1. The time now is 03:38 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"