Posted to microsoft.public.word.mailmerge.fields
|
|
Losing Formats, Excel to Word merge
Thanks Doug and Graham. All your suggestions fixed my issues. And Graham,
excellent web site!
"Graham Mayor" wrote:
The correct field and switch syntax would have been
{MergeField DOB_1 \@ "MMM dd, yyyy" }
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Jeeslawees wrote:
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.
|