Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected][_2_] carlsondaniel@gmail.com[_2_] is offline
external usenet poster
 
Posts: 7
Default Mail Merge with Excel - Date not Formatting Correctly

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
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word converts English date to USA date in mail-merge from Excel? DaveCujoPI Mailmerge 1 April 20th 07 03:04 PM
Mail merge from Excel file changes date formatting Colin in RSA Mailmerge 4 January 18th 06 08:26 PM
mail merge from excel-date in excel January 1, 2005 -merged dbase. Elaine Ballon Mailmerge 1 December 23rd 05 08:31 AM
mail merge using Word and Excel doesn't work correctly enolalum Mailmerge 2 October 29th 05 08:27 PM
Formatting Date in Mail Merge Chuck Mailmerge 2 August 10th 05 07:27 PM


All times are GMT +1. The time now is 05:09 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"