- #Mail merge word mac set default email program how to#
- #Mail merge word mac set default email program zip#
Repeat steps 1–3 for all columns containing numeric values.
![mail merge word mac set default email program mail merge word mac set default email program](https://help.hkis.edu.hk/hc/article_attachments/360007333393/Screen_Shot_2018-06-12_at_8.29.17_AM.png)
Click on the Number Format box and choose the correct format from the drop-down list that appears.Ĥ. Select a column that has numeric data entries.ģ.
#Mail merge word mac set default email program zip#
Only enter your column headers in the first row, starting in cell A1.Ĭheck your header row to make sure the column headers in your Excel spreadsheet are exactly the same as the field names (or placeholder names) you want to use in your Word template document.įor example, if the column names in your Excel sheet are “FirstName”, “LastName”, and “Email”, the field names in your Microsoft Word document should also be “FirstName”, “LastName”, and “Email”.Įnter your contact information in your Excel database as one record per row, starting from cell A2.ĭata entries such as ZIP codes, percentages, currencies, etc., must be in the correct numeric format. Now you can start entering the details of your address list into the Excel workbook. If the data is present in a TXT or CSV file, go to Data → From Text/CSV to open the file in Excel. Note: If your contact data is readily available as an Excel spreadsheet, open the file and format it. Open MS Excel and click on Blank workbook to open a blank Excel workbook (or document).
![mail merge word mac set default email program mail merge word mac set default email program](https://support.content.office.net/en-us/media/4682406c-3eb8-497c-812a-c256b0596350.png)
#Mail merge word mac set default email program how to#
Here’s a step-by-step guide on how to set up an Excel data file: Let’s now explore the steps involved in using mail merge for bulk letters: Step 1: Create and format your address list in Microsoft Excel