Solved

Date format in word 2007 mail merge

Posted on 2008-10-20
2
5,386 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
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…

728 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