May 20, 2016
There are three ways to make your dates and currency show properly in a Microsoft Word mail merge I’ll be showing you way number 1 in this blog and the other 2 in a subsequent blog.
1. Change how the merge connects to the Excel file
In the MS Word mail merge document go:
File – Options – Advanced
Scroll down to the General section, and then tick the box for Confirm file format conversion on open tick box then click on OK
Now start the mail merge and start the mail merge. After you decide on Letters, or Labels, or Envelopes, you’ll need to select the recipients, we’ll get some extra prompts because of the option we just turned on.
In the main document, click Mailings – Select Recipients – Use an Existing List. The browse to your spreadsheet and click on Open.
At this prompt, Tick the Show All tick box and then choose MS Excel Worksheets via DDE (*.xls), and then click on OK.
At this prompt click Entire Spreadsheet, and then click OK.
You can now continue with your mail merge!
Note: To stop Word giving you that prompt every time you open a data file, you can open Word Options menu again and untick the Confirm file format conversion on open tick box after you are done with this mail merge.
How do your Excel skills stack up?
Test NowNext up:
- InDesign CC - Colour Theme Tool
- What is a PCI-Express Lane?
- 4 TED Talks to help you overcome stress
- Managing Employees through Frequent Casual Feedback
- Automatic null checking in C# 6.0
- It isn’t the changes that do you in, it’s the transition
- Lies, Damned Lies, and Statistics
- Service Transition in ITIL®
- Finding just the working days in Excel
- Microsoft Azure Databases
Previously
- PowerShell Basics Series - Sorting and Selecting
- Course Divorce
- InDesign CC - Creative Cloud Libraries
- What to expect from SQL Server 2016
- Every Microsoft Word Keyboard Shortcut
- Linking a Worksheet Title to a Chart Title in Excel
- Creating “ME” time at work
- Interesting facts about Project Management
- Using the right black in InDesign
- A close shave