Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Mail Merge Dates
Hi
I'm having some problems with Mail merge and date formats. I have a spreadsheet which contains some dates in the dd/mm/yyyy date format eg Start_date Finish_Date 1/1/2005 30/6/2007 When I insert these fields in a mail merge document, I get them in the mm/dd/yyyy date format. My question is, Is there a way to change the format? coyotem78 |
#2
|
|||
|
|||
See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...r/MergFram.htm -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "coyotem78" wrote in message ... Hi I'm having some problems with Mail merge and date formats. I have a spreadsheet which contains some dates in the dd/mm/yyyy date format eg Start_date Finish_Date 1/1/2005 30/6/2007 When I insert these fields in a mail merge document, I get them in the mm/dd/yyyy date format. My question is, Is there a way to change the format? coyotem78 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Dates
I also have a problem with dates. I have them in an excel spreadsheet the
English way 4/8/06 for 4th August but when merged it is changing it to Amercian 8/04/06 how do I change it back "coyotem78" wrote: Hi I'm having some problems with Mail merge and date formats. I have a spreadsheet which contains some dates in the dd/mm/yyyy date format eg Start_date Finish_Date 1/1/2005 30/6/2007 When I insert these fields in a mail merge document, I get them in the mm/dd/yyyy date format. My question is, Is there a way to change the format? coyotem78 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Dates
See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...r/MergFram.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Sarah" wrote in message ... I also have a problem with dates. I have them in an excel spreadsheet the English way 4/8/06 for 4th August but when merged it is changing it to Amercian 8/04/06 how do I change it back "coyotem78" wrote: Hi I'm having some problems with Mail merge and date formats. I have a spreadsheet which contains some dates in the dd/mm/yyyy date format eg Start_date Finish_Date 1/1/2005 30/6/2007 When I insert these fields in a mail merge document, I get them in the mm/dd/yyyy date format. My question is, Is there a way to change the format? coyotem78 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge | |||
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements | Mailmerge | |||
Excel dates formatted d/m/yy convert to m/d/yy in mail merge | Mailmerge |