Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jeeslawees Jeeslawees is offline
external usenet poster
 
Posts: 9
Default Losing Formats, Excel to Word merge

Using 2007 versions, Vista OS.

In Excel, I have a date column labeled DOB_1 in my database, and that column
is formatted to display 'mmm dd, yyyy'. So, an entry of 9/5/2005 displays as
'Sep 05, 2005'.

Up until today, when Mail Merging that Excel file to Word, the 'Sep 05,
2005' is what was shown in the final Merge doc. Now all of sudden, the final
Merge doc is showing '9/5/2005', which is the Excel entry and NOT the cell
format display.

I just tried changing te mail merge field entry to { Mailmerge DOB_1\@ "mmm
dd, yyyy" } ..... but it had no effect.

There have been no updates to the Excel file or the Word mail merge
structure. So, why all of a sudden am I losing these display formats?

Thanks in advance for any help with this perplexing issue.
 
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 losing Zip Code format from Excel to Outlook? ArtGle Mailmerge 1 July 24th 08 06:24 AM
Number formats from Excel into mail merge R Ormerod Mailmerge 2 January 12th 07 04:17 PM
Pasting Text; losing formats Gerald Priddle Microsoft Word Help 1 April 28th 06 07:52 PM
How can I maintain Excel date formats in a mail merge? MKLeisure Mailmerge 1 August 30th 05 08:09 PM
Keeping number formats (eg. 5.15%) in Excel/Word Mail Merge Ximena Mailmerge 2 July 8th 05 10:36 AM


All times are GMT +1. The time now is 11:59 PM.

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

About Us

"It's about Microsoft Word"