Incorrectly imported data using mail merge

M

Mal konian

Hi,

Have a small prroblem. Have created a source document in Excel and am using
word to import into a series of templates but when merging data the date is
being transp[osed from Uk format (in source document) into US format in word
document.

Can anyone suggest a fix. Have che checked that all setting are UK format
mode.

Cheers,

Malkonian
 
D

DL

Copy from earlier post, from Beth

This is because you are using the default OLE DB data connection and
it only passes the data from Excel to Word which does not include
formatting.

You'll need to add a Date-Time picture switch to the merge field in
Word:

- Press Alt + F9 to toggle the field codes
- At the end of your date field add: \@ dd/MM/yy
- Press Alt + F9 to toggle off the field codes

Note that the month format must be in uppercase. A lowercase 'm' is
for minutes.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
 
Top