MAIL MERGE DATA PLEASE HELPPPPPPPPPPPPPP

[Beninjam91]

Hello, im in a pickle...

I have to mail merge a data caption form which includes dates (cant say more
data protection act etc). in the excel spreadsheet the dates are formatted in
english (dd/mm/yyyy) but when i merge to a new document Word changes the
dates to mm/dd/yyyy which is a problem for people who are born on the 1st of
July 1979 for example because it shows it as 07/01/79 not 01/07/79 so it
looks like the information is wrong to anyone reading it. HOW DO I CHANGE THE
DATE FORMAT??????????

ive been on microsft help and got diddly sqwat to show from 4 hours of
research....

can anyone help PLEASE!!!!!!!!!!!!!!!!!!!

 

[Beninjam91]

Ihave also went into word and changed the data and time format to english as
a default buty still it doesnt work

 

[macropod]

Hi Beninjam91,

This is really easy:
Select the mergefield and press Shift-F9. You should see something like: {MERGEFIELD ExcelDate}
Add a date picture switch to the field, thus : {MERGEFIELD ExcelDate \@ "dd/MM/yyyy"}

See "Apply formatting to information inserted by fields" and the associated links in Word's help file for more details - a help
search for 'field formatting' will turn it up.

 

[Doug Robbins - Word MVP]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Beninjam91]

Hey Doug i have followed your info and it has worked but it now inserts a
time as well as the date in the correct format but now i cannot open the file
i was merging from any ideas as to why???

 

[Doug Robbins - Word MVP]

Add a \@ "dd/MM/yyyy" formatting switch inside the closing } of the field
code that is displayed when you toggle on the display of field codes with
Alt+F9
--
Hope this helps.


Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP