Solved

Excel mailmerge to Word changing TEXT to DATE format

Posted on 2006-11-29
8
310 Views
Last Modified: 2010-05-18
Greetings all,

I have an excel file that I am using as the data source for a mail merge document.  One column is labeled SiteSurvey and it contains a date formatted as TEXT which has data such “11-15 September 2006”  “29 Oct – 4 Nov 2006” and so on.

When I add this field to the word document it only displays as 12:00:00 AM.  I gather that either word or excel is seeing this as a formula date field rather than a text field and is trying to convert it.  I don’t want it to convert anything I just want the straight text ported over.  Considering that it's formatted as TEXT in Excel I suspect Word is the culprit.

I’ve looked through the other solutions here relating to Excel/Word date problems and don’t see anything that relates.  I am using Office 2003/SP2 and everything has been updated/patched/hotfixed appropriately.  

Any help, advice, or ideas would be welcome. I have 130 of these documents to merge/create by yesterday so I'm a little pressed for time - thus the 500 points offered.

Regards,

Bart
0
Comment
Question by:mullinsbc
8 Comments
 
LVL 14

Expert Comment

by:Glenn_Moore
ID: 18038056
0
 
LVL 1

Author Comment

by:mullinsbc
ID: 18038720
Thanks Glenn.  I had seen that earlier in my search but it wasn't helpful.

I just found the answer though and came here to post what I found.

http://office.microsoft.com/en-us/word/HA011164951033.aspx

The fix was under the "Use Dynamic Data Exchange."  Its a bit clunky because I now have to confirm a data conversion everytime I want to use that excel file, but at least it works.

0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 18038779
I can  only reproduce that problem if the field is unnecessarily formatted with a date switch, like

{ MERGEFIELD "daterange" \@ "hh:mm:ss" }

(Field code display can be toggeled on and off weith Alt + F9)
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 1

Author Comment

by:mullinsbc
ID: 18041827
Mine was only { MERGEFIELD "SiteSurvey" } with nothing else.
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 18041873
Didn't see your penultimate post.

DDE was the old default and ODBC is the new default. DDE copies what you see, rather than the underlying values, though simple text should appear the same with either method.

You can ask for a points refund in the Support area.
0
 
LVL 1

Author Comment

by:mullinsbc
ID: 18044756
True, text is text is text and it should port over with no problems.  I take some measure of comfort in knowing that I'm not the only one with the issue - Microsoft posted a work around for it so I reckon that the problem has been known for a while.  The down side is - Microsoft posted a work around for it so I reckon that the problem has been known for a while.  :-)

0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 18077446
PAQd, 500 points refunded.

DarthMod
CS Moderator
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When creating Microsoft Word-based forms there may be a need to have a form field repeated throughout the whole document. For instance, with a company name, you may want this information repeated automatically throughout the document rather than man…
The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question