Mail merges

Resolved · Low Priority · Version 2010

Wed 13 Mar 2013, 17:05 Delegate Laura said...

Laura has attended:
Multiple applications course

Mail merges

Sometmes, when you are merging you format date cells in Excel and then when you merge the data with Word, it changes the date format. Why is this?

Thu 14 Mar 2013, 15:23 Trainer Andrew said...

RE: Mail merges

Hi Laura

Thank you for your question. Can you check what format has been applied to the cells containing dates in your spreadsheet. For example are they date format, with UK locale? You can check this by right clicking on a date in Excel and choosing Format > Cells > then click on the Number tab.

If the Locale is not UK then you may find the dates changed when they are imported into Word (which uses your PC's Locale to determine the date).

I have found an interesting suggestion on a Microsoft Forum relating for forcing the date format in a Merge document. It does in involves editing the merge field codes.

http://answers.microsoft.com/en-us/office/forum/office_2010-word/date-fomat-problem-in-mail-merge-word-2010/91e86ec7-1176-e011-8dfc-68b599b31bf5?auth=1

Let me know what you find in your spreadsheet and if changing the merge code looks like it might help.

Kind regards,
Andrew

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Copying From Websites

If you find some interesting text on a website that you wish to use and adapt in your wordprocessor or other package, highlight and copy in the normal way first.

When you paste though, use the Paste Special option to insert as unformatted text. That cuts out all the fancy formatting and hyperlinks that may be embedded.

View all Microsoft Office hints and tips