Solved

Date format in word 2007 mail merge

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

726 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