Hello,
I want to create letters to send to donors with the date of the donation. In the tables I want the date/time format to remain 10/30/2003, but when I do the mail merge I want it to be displayed: October 30, 2003. IS there anyone who can help?


Thanks

Mike

Change the format of the field to mmmm d", "yyyy and that should do it.

For your info, dates and times are stored as numbers in MS products and can be formatted anyway you choose really.

Having re-read your question, do you mean mailmerge with word? If so there is another technique you can use. merge with the table 'as is' and use a 'switch' it word to change the format.

{MERGEFIELD YourField\@ "d MMMM, yyyy"}

Insert your field into your document then press Alt-F9 to toggle to field view. now add \@ "d MMMM, yyyy" after 'YourField'

Important to note as I couldn't figure out why this wasn't working, you must update field after you apply this change :D