#1
|
|||
|
|||
Mail Merge Date Error
Hello,
I have a mail merge document which pulls multiple dates. The mail merge formula is: MERGEFIELD Vest_Date_1\@ "MMMM dd, yyyy" First three dates comes out in correct format January 01, 2017, however the other dates pulls as random number. What I am doing wrong? My data runs up to Vest_Date_25, meaning I have 25 Dates and only first 3 dates are coming in right format. Excel data is currently set to date "01/01/2017. Please help me, I need to send these letters out today. |
#2
|
||||
|
||||
That suggests most of your dates have been input as text, not as dates. Perhaps there is a space character before the date, for example.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
@macfopod: for reason I dont know, but when i changed the header for the column the date merge worked.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Error | mklindquist0815 | Mail Merge | 1 | 07-14-2017 08:36 PM |
mail merge error in vba | texas1014 | Word VBA | 2 | 03-08-2017 03:25 PM |
vba error when trying to do a mail merge | texas1014 | Mail Merge | 1 | 03-08-2017 03:23 PM |
Date picker mail merge error. | dan1 | Mail Merge | 7 | 06-28-2012 03:00 AM |
Mail merge error? | SRE | Outlook | 0 | 01-11-2010 05:54 PM |