Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MAIL MERGE DATA PLEASE HELPPPPPPPPPPPPPP
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!!!!!!!!!!!!!!!!!!! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MAIL MERGE DATA PLEASE HELPPPPPPPPPPPPPP
Ihave also went into word and changed the data and time format to english as
a default buty still it doesnt work "Beninjam91" wrote: 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!!!!!!!!!!!!!!!!!!! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MAIL MERGE DATA PLEASE HELPPPPPPPPPPPPPP
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. -- Cheers macropod [MVP - Microsoft Word] "Beninjam91" wrote in message ... 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!!!!!!!!!!!!!!!!!!! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MAIL MERGE DATA PLEASE HELPPPPPPPPPPPPPP
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/cindy...r/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" wrote in message ... 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!!!!!!!!!!!!!!!!!!! |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MAIL MERGE DATA PLEASE HELPPPPPPPPPPPPPP
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" wrote: 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/cindy...r/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" wrote in message ... 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!!!!!!!!!!!!!!!!!!! |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MAIL MERGE DATA PLEASE HELPPPPPPPPPPPPPP
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 "Beninjam91" wrote in message ... 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" wrote: 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/cindy...r/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" wrote in message ... 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!!!!!!!!!!!!!!!!!!! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add data fields to a data source in Word Mail Merge? | Mailmerge | |||
mail merge can't locate my data source which IS mail merge | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
How do I move data Colums within the data source of a mail merge | Microsoft Word Help | |||
data in mail merge letter being cut off - data source field size? | Mailmerge |