Reply
 
Thread Tools Display Modes
  #1   Report Post  
MKLeisure
 
Posts: n/a
Default How can I maintain Excel date formats in a mail merge?

I have an Excel spreadsheet with the date column formatted to display the
dates in character format (March 27,2005). When I do the mail merge with a
Word document the date reverts to the fomat it was enterd in 03/27/2005. How
can I get it the maintain the character format in the letter? Additionally
this information is imported into the Excel spreadsheet from a database.

Thanks
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.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
"MKLeisure" wrote in message
...
I have an Excel spreadsheet with the date column formatted to display the
dates in character format (March 27,2005). When I do the mail merge with a
Word document the date reverts to the fomat it was enterd in 03/27/2005.
How
can I get it the maintain the character format in the letter? Additionally
this information is imported into the Excel spreadsheet from a database.

Thanks



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
Mail Merge of a Date from Excel Data into Microsoft Word Keith A Microsoft Word Help 2 August 31st 05 05:01 AM
Excel serial date formats BarbH Mailmerge 3 August 20th 05 04:20 AM
Date mail merge from Excel to Word Jenny Microsoft Word Help 4 July 18th 05 04:38 PM
How do I control date formatting in a Word Mail Merge? Ric McWaters Mailmerge 1 April 21st 05 04:23 PM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM


All times are GMT +1. The time now is 02:07 PM.

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

About Us

"It's about Microsoft Word"