Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Elaine Ballon
 
Posts: n/a
Default mail merge from excel-date in excel January 1, 2005 -merged dbase.

I have an excel database with dates. I have formatted the dates in excel so
they are January 1, 2006 - When I do a merge using my excel sheet as the
information database, the columns that have the date spelled out change to a
date of 1/1/06. What can I do so the date colums format does not change
during the merge.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default mail merge from excel-date in excel January 1, 2005 -merged dbase.

Word ignores any formatting from Excel so you have to apply it in Word using
a formatting switch http://www.gmayor.com/formatting_word_fields.htm
In this case {Mergefield datefieldname \@ "MMMM d, yyyy"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Elaine Ballon wrote:
I have an excel database with dates. I have formatted the dates in
excel so they are January 1, 2006 - When I do a merge using my excel
sheet as the information database, the columns that have the date
spelled out change to a date of 1/1/06. What can I do so the date
colums format does not change during the merge.



Reply
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 2002 cannot find its Excel data source for mail merge harryedwards Mailmerge 5 November 23rd 05 12:09 PM
Mail Merge document and Date field niv Mailmerge 3 November 22nd 05 09:50 PM
Mail Merge: Excel (XP) fields scrambled during merge Adprof Mailmerge 1 November 10th 05 07:43 PM
Attaching different Excel files to emailed mail merge using merge. Pete Cuff Mailmerge 1 November 3rd 05 07:54 PM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 02:13 PM


All times are GMT +1. The time now is 03:09 PM.

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"