Reply
 
Thread Tools Display Modes
  #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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Losing Formats, Excel to Word merge

In Word, click on the Office button and then on Word Options and then on
Advanced and scroll down to the General section and check the box against
the "Confirm file format conversion on open" item and then when you attach
the data source to the mail merge main document, choose the DDE option in
the dialog box that appears.

--
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, originally posted via msnews.microsoft.com
"Jeeslawees" wrote in message
...
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.


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Losing Formats, Excel to Word merge

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.



  #4   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

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.




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 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 05: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 04:42 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"