Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
LostinLA LostinLA is offline
external usenet poster
 
Posts: 1
Default Need to pull in a date from excel into a merged word doc as mmm d

I can't seem to figure out how to get mmm d vs. the serial number into the
word doc....
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Need to pull in a date from excel into a merged word doc as mmm d

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button Word Options Advanced General Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



LostinLA wrote:
I can't seem to figure out how to get mmm d vs. the serial number
into the word doc....



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word07 displays merged date from Excel as serial Carol Mailmerge 1 July 14th 09 10:27 PM
Date fields are merged incorrectly when I use an Excel data source Jemdlee Mailmerge 4 May 30th 07 12:56 PM
IF then with merged date field from excel Holly Mailmerge 3 January 14th 06 07:05 AM
mail merge from excel-date in excel January 1, 2005 -merged dbase. Elaine Ballon Mailmerge 1 December 23rd 05 08:31 AM
How to correct too much decimals and date if merged from Excel? Stefanus Mailmerge 1 July 15th 05 08:00 PM


All times are GMT +1. The time now is 06:23 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"