Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Please Help - Mail merge changes format of field when merged
Just updated to Word 2003. When I merge with database held in Excel 2003
field with date changes from Australian format I typed in to American format, eg 31/12/2004 changes in merged field to 12/31/2004. I've made sure my settings are all set to use Australian everything but it still changes in the process of merging. How do I fix this problem. I know that I can manually change after fields have been merged but it is a real pain, I've never had this problem in the previous versions of Word I have used. Any help would be greatly appreciated. Thanks. |
#2
|
|||
|
|||
See the Excel data section of
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NeetaV wrote: Just updated to Word 2003. When I merge with database held in Excel 2003 field with date changes from Australian format I typed in to American format, eg 31/12/2004 changes in merged field to 12/31/2004. I've made sure my settings are all set to use Australian everything but it still changes in the process of merging. How do I fix this problem. I know that I can manually change after fields have been merged but it is a real pain, I've never had this problem in the previous versions of Word I have used. Any help would be greatly appreciated. Thanks. |
#3
|
|||
|
|||
Thank you so much for your help.
"Graham Mayor" wrote: See the Excel data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NeetaV wrote: Just updated to Word 2003. When I merge with database held in Excel 2003 field with date changes from Australian format I typed in to American format, eg 31/12/2004 changes in merged field to 12/31/2004. I've made sure my settings are all set to use Australian everything but it still changes in the process of merging. How do I fix this problem. I know that I can manually change after fields have been merged but it is a real pain, I've never had this problem in the previous versions of Word I have used. Any help would be greatly appreciated. Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge with attachments | Mailmerge | |||
Switch an image dynamically based on mail merge field - possible? | Mailmerge | |||
Mail Merge needs to return to 2000 format | New Users | |||
How can I edit the format of a mail merge field after it has been. | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |