Solved

Date format in word 2007 mail merge

Posted on 2008-10-20
2
5,379 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 500 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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

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