#Mail merge with word for mac 2011 how to#

The Mail Merge Manager built into Microsoft Word for Mac makes it easy to import, then edit and print. All the Mac computers which dont have the privilege to upgrade to MacOS High Sierra or the computers that. Use the IF() function to handle special situations like empty or unusual values.īest of all, you can easily check the results by scrolling down the column to see the transformed text as it’ll appear in the merged documents. If you use Microsoft Office 2011 on a Mac computer, you can easily import addresses or other data from an Excel spreadsheet or from your Apple Contacts and add them to Avery Labels, Name Badges, Name Tags or other products.

The original field ‘Date’ can be formatted as text as ‘Date_Formatted’. Another and better wayĮxcel has much better formatting and data transformation options than Word.įor many years, we prefer to do all the formatting in Excel, with additional fields (columns) that have the dates, amounts etc as text formatted as you like. UK post codes includes letters and should be stored as text. See the merge codes (Alt + F9 – toggles the display of field codes vs results) then add formatting codes.īecomes something like That’s because Word has it’s own formatting options. When Word imports mail merge data it only imports the raw data, not the formatting used in Excel. Important: you should save these both to your desktop before starting, since you will have to browse to find the Excel file when merging. Weve developed a suite of premium Outlook features for people with advanced email and calendar needs. Mail Merge Database Excel File: this is a fictional database for linking to the merge document. This is a fictional letter for potential students. When I merge the files, the amount drops of the ending zeros (such as 68.5 and 128). Sample Letter Word Document: this is your file that you would like to turn into a merged PDF for recipients. In the Excel database the amount cells are formatted for currency with 2 decimal places and the date cells are formatted as Feb. “ I try to merge data (such as amount, PO#, to whom, as well as the date) from an Excel database.

#Mail merge with word for mac 2011 how to#

How to change the look of Word mail merge data like dates and dollar amounts to exactly what you want to see in the documents.