Thread: [Solved] Mailmerge Data Format
View Single Post
 
Old 09-29-2013, 07:35 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Changing the date format in Excel won't help unless you also change the mailmerge data connection method to DDE. You'd do better to add a date formatting switch to the mailmerge field instead of messing with Excel.

To get the date format you want, you can add a formatting picture switch as follows:
• select the mergefield;
• press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where 'MyDate' is your mergefield's name;
• delete anything appearing after the mergefield's name and add '\@ "dd MMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "dd MMM yyyy"}. With this switch your date will come out as '02 Aug 2008', for example.
• position the cursor anywhere in this field and press F9 to update it;
• run your mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote