Mail Marge to display date differently to 12/09/08

Mail merge in word natrually displays 31/01/2007 however I would actually like to display the date as follows
Thursday 31st January.
It is getting the information from a very simple access database. I know you can right click and edit the field format from within word but I cant work out how you can get it to display like above.
Please help.
Mick
LVL 1
michaeldiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dubrovnik4Commented:
Right click on the field and enter \@ "dddd dd MMMM"
to be honest, I don't know how to get the nd rd or st....
0
sah18Commented:
To change the date format of a merge field, you need to edit the merge field code itself.

In your word mail merge doc, press Alt+F9 -- this will show up all the merge field codes.
Go to the field with the date you wish to format.
Edit the code for that field as follows:

{MERGEFIELD "date" \@"dddd d MMMM"}

(where "date" would be replaced with whatever the name of your date field is)

After you've edited the code, just press Alt+F9 again to toggle back to the normal view.

Let me know if you have any questions!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brian PiercePhotographerCommented:
its actually gong to be \@ dddd dd MMMM yyyy
to get it in the format specified.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

sah18Commented:
The format KCTS specified, will add the year, which it looked like you didn't want.

Hey, I found a really helpful site at this page:
http://www.gmayor.com/formatting_word_fields.htm

Scroll down to the section "Date fields with ordinals" and it gives you syntax to address adding the st, rd, nd (that I missed in your original question!).

If you have questions of us, please just ask!
0
Brian PiercePhotographerCommented:
Opps sorry - my mistake - must put my galsses on 8-)
0
GrahamSkanRetiredCommented:
You will need to insert the mergefield three times if part of it has to be formatted as an ordinal number.

The fields will look like:

 { MERGEFIELD MyDate  \@  "dddd"} { MERGEFIELD MyDate \@  "d" \*Ordinal} { MERGEFIELD MyDate    \@ "MMMM" }

0
Jeffrey CoachmanMIS LiasonCommented:
michaeldi,

The only other option I can think of is...

If this format is what you want all the time...
Then perhaps it would be best to change the "Source" to be formatted as dddd dd MMMM yyyy, so as to avoid converting it every time.

This is easiest if the Data is in Excel, simply highlight the date Field and click: Format-->Cells.
Then Select "Date" from the Category section... there will be a Date format listed that is similar to what you want.

In Access, open the source table in design view, select the Date field.
Near the bottom of the screen you will see a property called "Format".
You will select: "Long Date"

The good news is that in either program you can literally type in the format directly.

HTH as well

JeffCoachman
0
GrahamSkanRetiredCommented:
The default transfer method (ODBC) does not copy the formatting options in Excel or Access, but works with the underlying data only. Changing the display format in those two applications will not normally make any difference to the mail merge formatting.

You would have to force a DDE transfer (the default in Office 97)
0
Jeffrey CoachmanMIS LiasonCommented:
GrahamSkan,

oops, sorry, you are correct.
I was thinking about Queries/Tables to Reports.
:(

JeffCoachman
0
GrahamSkanRetiredCommented:
Don't be sorry, Jeff.

That fact is not generally known - it's not in the Help documentation - and we are all here to learn.
0
Jeffrey CoachmanMIS LiasonCommented:
GrahamSkan,
So true.
:)

<OT>
You should more time with us over in the Access TA!
:)
How are you liking Office 2007?

JeffCoachman
0
michaeldiAuthor Commented:
Thank you for your answer. I was able to do it but given up on getting the nd, th st etc on the end.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.