Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
wrong date format in mail merge
I am using Office 2007 on XP. I am doing a mail merge in Word with Excel as
my data file. I have 2 columns: name and date. My number format for Date is set under Date Type to April 20, 2009, which is the spelled out date. When it merges, I get 4/20/2009. How can I fix this? Thanks. |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
wrong date format in mail merge
Date formatting in Excel is a property of the cell containing the date
value, not a property of the data itself. To have it render the way you want it, right-click the date field in your Word main document & select Edit Field. Click the Field Codes button, then add the following mask at the end of the MERGEFIELD [field_name]: \@ "MMMM d, yyyy" After you OK out, hit the Update Labels button in the Mailings Tab Write & Insert Fields group of Ribbon. -- HTH |:) Bob Jones Office:Mac MVP "Trainer" wrote in message ... I am using Office 2007 on XP. I am doing a mail merge in Word with Excel as my data file. I have 2 columns: name and date. My number format for Date is set under Date Type to April 20, 2009, which is the spelled out date. When it merges, I get 4/20/2009. How can I fix this? Thanks. |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
wrong date format in mail merge
Thank you. It works okay now that I did as you said.
"CyberTaz" gtz1@comcastdotnet wrote in message ... Date formatting in Excel is a property of the cell containing the date value, not a property of the data itself. To have it render the way you want it, right-click the date field in your Word main document & select Edit Field. Click the Field Codes button, then add the following mask at the end of the MERGEFIELD [field_name]: \@ "MMMM d, yyyy" After you OK out, hit the Update Labels button in the Mailings Tab Write & Insert Fields group of Ribbon. -- HTH |:) Bob Jones Office:Mac MVP "Trainer" wrote in message ... I am using Office 2007 on XP. I am doing a mail merge in Word with Excel as my data file. I have 2 columns: name and date. My number format for Date is set under Date Type to April 20, 2009, which is the spelled out date. When it merges, I get 4/20/2009. How can I fix this? Thanks. |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
wrong date format in mail merge
Thanks for the confirmation. Glad it worked out well.
-- Regards |:) Bob Jones Office:Mac MVP "Trainer" wrote in message ... Thank you. It works okay now that I did as you said. "CyberTaz" gtz1@comcastdotnet wrote in message ... Date formatting in Excel is a property of the cell containing the date value, not a property of the data itself. To have it render the way you want it, right-click the date field in your Word main document & select Edit Field. Click the Field Codes button, then add the following mask at the end of the MERGEFIELD [field_name]: \@ "MMMM d, yyyy" After you OK out, hit the Update Labels button in the Mailings Tab Write & Insert Fields group of Ribbon. -- HTH |:) Bob Jones Office:Mac MVP "Trainer" wrote in message ... I am using Office 2007 on XP. I am doing a mail merge in Word with Excel as my data file. I have 2 columns: name and date. My number format for Date is set under Date Type to April 20, 2009, which is the spelled out date. When it merges, I get 4/20/2009. How can I fix this? Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge address block name format is wrong | Mailmerge | |||
Mail Merge Date Format | Microsoft Word Help | |||
wrong date display in mail merge | Mailmerge | |||
Wrong mail merge date format | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |