Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
On Wednesday, April 16, 2008 at 5:27:00 PM UTC-7, wrote:
Hello, I am having some issues with my Mail Merge. I am using Word and Excel 2003. I am bringing over some dates from Excel into Word using Mail Merge. The format I would like to see for example, is April 7, 2007. I have numerous dates that are tying into this Word document and I have added the switch \@ "MMMM d, yyyy" to all of the MERGEFIELDS and they are working fine, except for one. I get the serial date of 39179. I have added the switch, deleted it, closed, opened, updated fields etc.. to see if it will register but to no avail. I know Excel and Word are communicating because when I change the date in Excel, the serial date in Word changes to match. It is only this one cell that is not working in this document. Any suggestions would be greatly appreciated. Thank you in advance for your time. Dan That was a fail for me. I chose DDE and it lost all my fields and replaced them with some AutoMerge field. Thanks Microsoft. |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Word converts English date to USA date in mail-merge from Excel? | Mailmerge | |||
Mail merge from Excel file changes date formatting | Mailmerge | |||
mail merge from excel-date in excel January 1, 2005 -merged dbase. | Mailmerge | |||
mail merge using Word and Excel doesn't work correctly | Mailmerge | |||
Formatting Date in Mail Merge | Mailmerge |