Dates as text in Mail merges

=?Utf-8?B?Q2FuZGlkYQ==?=

Guest

Posts: n/a

17th Aug 2007

Hi, I'm trying to do a mail merge between a Word Document and an Excel
spreadsheet. I'm using the latest ('07) versions of both programs.

I have several columns of dates in my data (such as original; billing date,
due date, etc.) I have them formatted as dates in Excel. My problem is
that when I do the merge, Word reads them as numbers such as 38982 or the
like. I have tried converting the date columns to text in Excel, but then ALL
the dates look like their serial numbers. How can I get around this?

« new pivot table user with filter question | Macro for Copying Worksheet to New Workbook »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: Dates as text in Mail merges	=?Utf-8?B?RHVrZSBDYXJleQ==?=	Microsoft Excel Misc	0	17th Aug 2007 01:44 AM
Outlook 2003 should let me send plain text mail merges	=?Utf-8?B?SmFuZSBDYXJuYWxs?=	Microsoft Outlook Discussion	1	28th Apr 2006 10:00 AM
Mail Merges	Scott	Microsoft Outlook Contacts	1	14th Oct 2003 09:04 PM
mail merges	Darlene	Microsoft Word New Users	2	26th Sep 2003 04:01 AM
Mail merges	Marcel van Kempen	Microsoft Access VBA Modules	1	9th Sep 2003 01:33 AM