Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Date format in word 2007 mail merge

Posted on 2008-10-20
2
Medium Priority
?
5,397 Views
Last Modified: 2012-05-05
Hi experts,

I'm having a problem with the format of a date field when mail merging in Word 2007 with Excel data. It usually works fine, but in some cases the date shows up in Word as 39455 instead of "8 January 2008". In Word, I'm using this: {MERGEFIELD  Date_of_Inc \@ "d MMMM yyyy"}. In Excel, the dates come all from the same column and they are all formatted as dates (the first date type).

Any clues?

Thanks!
J
0
Comment
Question by:jiiins2
2 Comments
 
LVL 16

Expert Comment

by:Calvin Brine
ID: 22759106
I've not tried to use 2007 for a mail merge as yet, but 2003 suffered from the same issue.  The way that I get around it is to encapsulate your results using the text formula.
=Text(A12,"mmm dd, yyyy")
This will force the value to text, so when word reads it, you get the correct results.  
I don't know about Word 2007, but the control codes in 2003 didn't work according to what the instructions stated.
 
HTH
Cal
0
 
LVL 19

Accepted Solution

by:
dlc110161 earned 2000 total points
ID: 22761438
Hi -

Try making Word prompt you for the type of Excel document you are using. You will want to be sure and use the Confirm file format conversion on open (Office Button / Word Options / Advanced - General group)

Then when you perform your merge, use the OLE DB Database file format, so that you can better control the format of your data coming from Excel.

Dawn Crosier-Bleuel
Word MVP
Confirm-File-Format.gif
Data-Source.gif
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
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 …

963 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