How to Mail Merge from MS Word and Excel (Updated Guide)

Looking for:

Change Mail Merge Formatting of Mail Merge Fields in a Word Document 

Click here to DOWNLOAD

   

 

How to format date, currency and number during mail merge in Word?

 

Working with the mail merge feature in Microsoft Word is a time-saving option to create repetitive, custom-tailored documents from letters to contracts to emails to labels and more. Whether you are bringing data in from an Excel worksheet, an Access database, or a Word table, you may sometimes want the flexibility of applying different or consistent formatting to text or date fields as you reference them throughout your mail merge documents.

Or, perhaps you want to change the display of date microsoft office 2010 free 64 bit with product key free fields especially if the original date is not merging with the correct format. Fortunately, there are options to customize the format of date or text fields without creating multiple versions in the original data source.

How can you apply custom text or date formats to a mail merge field to accurately display the formatted text in a Word mail microsoft word 2013 mail merge date format free main document? Try this formatting fix on letters, emails, and other documents that link to mail merge data from Excel, Word, or Access.

In this sample letter, the Company /51502.txt is a microsoft word 2013 mail merge date format free field from a linked recipient list. When the results are previewed, the company name displays as it was originally entered.

With a simple edit, the field can be changed to display the case formatting you want in the document such as all upper case. Simply highlight the entire merge field and apply the formatting from the Microsoft Word Home tab in the Ribbon. Try these options for formatting date and text mail merge fields to get the results you want in your documents.

And, learn more about the numeric switches available to control the formatting of Excel or other numeric mail merge data. Discover more ways to save time editing and formatting your Word documents at TheSoftwarePro. Dawn shares smart and easy ways to effectively use software through her work as a productivity speaker, software trainer, virtual presenter, and author of hundreds of training courses and videos. Understanding Microsoft Word Formatting. Use yy to display the last two digits of any year.

Use yyyy to display all four digits of any year. Use MM to display the month in microsoft word 2013 mail merge date format free digits with a leading zero for single-digit months such as 09, Use M to display the month in digits such as 9, Use dddd to spell out the day of the week such as Sunday, Monday. Use ddd to display the three letter abbreviation of the day such as Sun, Mon.

Use dd to display the day in two digits with a leading zero for single digit days such as 09, Use d to display the day in digits such as 9,

 

Microsoft word 2013 mail merge date format free

  The merge fields come from the column headings in the data source. aren't formatted right, see Prepare your Excel data source for a Word mail merge. Note: If your contact data is readily available as an Excel spreadsheet, open the file and format it. If the data is present in a TXT or CSV. Controlling Date Formats in a Mail Merge · Choose Options from the Tools menu. Word displays the Options dialog box. · Choose the General tab. .