Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Bobbie @ NPH
 
Posts: n/a
Default Mail Merge with Original Formatting?

We are trying to create a letter using mail merge. One of the headers in
Excel is a date. It is formatted as a date in Excel to appear as "Month dd,
yyyy."

When we insert it into the letter using mail merge, it immediately changes
it to the format "mm/dd/yyyy" (but uses the correct date listed in Excel). I
right click the field and change the format to date and select the "month,
dd, yyyy" format. But then I only have the option of using the current date,
the create date, or the last saved date. I can't use the original date
inserted into Excel.

Any one know why this is or how to get around it? We would really like to
be able to insert the date from Excel in the format "month dd, year."

Thanks,
Bobbie
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mail Merge with Original Formatting?

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

"Bobbie @ NPH" wrote in message
...
We are trying to create a letter using mail merge. One of the headers in
Excel is a date. It is formatted as a date in Excel to appear as "Month
dd,
yyyy."

When we insert it into the letter using mail merge, it immediately changes
it to the format "mm/dd/yyyy" (but uses the correct date listed in Excel).
I
right click the field and change the format to date and select the "month,
dd, yyyy" format. But then I only have the option of using the current
date,
the create date, or the last saved date. I can't use the original date
inserted into Excel.

Any one know why this is or how to get around it? We would really like to
be able to insert the date from Excel in the format "month dd, year."

Thanks,
Bobbie



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
Adding a field to an Off 97 mail merge using Office Pro 2003 TomC Mailmerge 1 January 5th 06 08:00 AM
Mail Merge Losing Data Scott May Mailmerge 1 November 1st 05 11:03 PM
Zip+4 formatting in mail merge HoyaJane Mailmerge 4 August 1st 05 06:37 PM
Excel Formatting in Mail Merge dpahlow@nwtc Mailmerge 1 July 29th 05 06:25 PM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 04:11 AM


All times are GMT +1. The time now is 11:36 AM.

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"