![how to do a mail merge from excel to word how to do a mail merge from excel to word](https://d295c5dn8dhwru.cloudfront.net/wp-content/uploads/2019/05/15102009/Figure-2.-Excel-mail-merge-template.png)
![how to do a mail merge from excel to word how to do a mail merge from excel to word](https://i.ytimg.com/vi/lxHBX222HoM/maxresdefault.jpg)
Here, you can select your label brand and product number. In the drop-down menu that appears, select Labels.
HOW TO DO A MAIL MERGE FROM EXCEL TO WORD ZIP
Format Numerical Data Correctly: Be sure that things like street numbers and zip codes are properly formatted for the way they should appear once the mail merge is complete. Next, head over to the Mailings tab and select Start Mail Merge.Also, make sure the headers you choose match the merge field names, which will also make it less likely errors will occur. To make it easy for Excel to differentiate between data and labels, use bold text, cell borders, and cell shading that are unique to the header row. A header row is a row containing labels that identify the data in the cells beneath it. Create a Header Row: Create a header row for the sheet you intend to use for the mail merge.Also, make sure the sheets are clearly named, as you have to select the one you intend to use without being able to view it. If it's spread across multiple sheets, combine the sheets or perform multiple mail merges. Put All Data on a Single Sheet: The mailing list data you intend to use for the mail merge must be on one sheet.You’ll see the drop-down menu of some mail merge labels from the column names. Click on Insert Merge Field from the Write and Insert Fields group. Other mail merge fields such as first name, email, company name, job title etc. On the Home tab, in the Number group, choose the Number Format (General) box down arrow, and then choose an option in the list. Insert Merge field insert other mail merge fields from your Excel file. To preserve numeric data you've formatted as a percentage or as currency during a mail merge, follow the instructions in the "Step 2: Use Dynamic Data Exchange (DDE) for a mail merge" section. You can prepare your document the way you want and add placeholders for the. When done, save your data source with a new file name.įormat any numerical data like percentages or currency values in any new or existing data source in Excel that you intend to use in a Word mail merge. Mail merge in Microsoft Word allows you to send personalized letters and emails without having to customize each letter. Mail merge - A free, 10 minute, video training Use mail merge to create and send bulk mail, labels, and envelopes In your mail merge document, you add the symbols before or after the merge fields like this: If you include the symbols, the numbers make more sense. For example, here's how the currency and percentage values look if you omit symbols. Make sure you add the appropriate symbol before or after a merge field. Go to Home, and in the Number group, select the Number Format box down arrow, and then choose an option in the list (such as Text).
HOW TO DO A MAIL MERGE FROM EXCEL TO WORD HOW TO
Microsoft Word 2010 - How to do a Mail Merge. Leading zeros-for example, 00399-in codes are dropped during a mail merge if they're not formatted as text.Ĭhoose the column that contains the ZIP Codes, postal codes, or other data to be formatted. When performing a mail merge from Excel into a Word document it is common to have some formatting problems. If not done when imported, format it now. ZIP Codes or postal codes needs to be formatted as text to preserve the data during a mail merge. Format a column of percentages as text if you want to avoid that multiplication factor. If you choose percentage as a category, be aware that the percentage format will multiply the cell value by 100. Format a column with numbers, for example, to match a specific category such as currency. In your Excel data source that you'll use for a mailing list in a Word mail merge, make sure you format columns of numeric data correctly. Save your spreadsheet with a new file name. Data is imported beginning with the named cell address.
![how to do a mail merge from excel to word how to do a mail merge from excel to word](https://media.cheggcdn.com/study/050/0503067a-a255-4c07-8991-31dcf12c977f/image.png)
Caution: The cell address in the Import Data dialog box shows the currently selected cell.