Date Formats

[Gillian Simpson]

Hi - ive merged a list of dates in Excel into a Word document. Regardless of how i format the date in excel, it transfers to Word as 8/23/2017 - i want it to display as Wed 23 Aug 2017 - as it is displayed in Excel i.e. ddd dd mm yyyy - i thought about trying to convert the dates to "text" in excel (woth copy, paste special as values) cos this i reckon wud work - but couldnt get that right - any suggestions pls?

 

[macropod]

See Mailmerge Date Formatting in the Mailmerge Tips and Tricks thread at:
http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html
or:
http://windowssecrets.com/forums/showthread.php/163017-Word-Mailmerge-Tips-amp-Tricks

 

[Gillian Simpson]

See Mailmerge Date Formatting in the Mailmerge Tips and Tricks thread at:
http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html
or:
http://windowssecrets.com/forums/showthread.php/163017-Word-Mailmerge-Tips-amp-Tricks

Tx i actually managed to do it just now - bringing in file from excel with dde option - eish im getting there slowly but surely!

 

[macropod]

DDE is the last method I'd use to deal with something like this; it's extremely limited compared to the default OLE DB. All you need do is add the switches as described - a trivial undertaking.

 

[Gillian Simpson]

DDE is the last method I'd use to deal with something like this; it's extremely limited compared to the default OLE DB. All you need do is add the switches as described - a trivial undertaking.

Yip got it right on my own ! Geez this is a whole new learning curve but loving it!