Solved

Excel mailmerge to Word changing TEXT to DATE format

Posted on 2006-11-29
8
308 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
*Best* PDF to Word Convertor 4 112
Numerous files can not be opened anymore 17 63
Free Online PDF Converter 2 48
Microsoft Word Pop Up Form 7 34
This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

895 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now