#Mailings tab in excel code#

In the 'Insert Address Block' dialog box, choose the style you want to use to insert the data - you should see the first entry in the data table as an example.ġ4. In the 'Write & Insert Fields' section of the ribbon, click 'Address Block.'ġ3. Make sure to check the box for 'First row of data contains column headers.' Then, click 'OK.' Select the sheet in the workbook that contains the mail merge data table, check the box, and click 'OK.'ġ2. If you created a new spreadsheet for this purpose, there will only be one. In the 'Select Table' dialog, choose the sheet that contains your data table. If you saved it in the 'My Data Sources' folder, it should be in the default location for mail merges.ġ1. Find the Excel spreadsheet you created and select it. Click 'Select Recipients,' and in the drop-down, choose 'Use an Existing List…'ġ0.

Quick tip: In the 'Start Mail Merge' drop-down, you can also select 'Step-by-Step Mail Merge Wizard' at the bottom of the list for a more guided run-through of the mail merge process.ĩ. Start the mail merge process by clicking the 'Start Mail Merge' button in the ribbon, and selecting a template type. You shouldn't see any change in the document. For this example, we'll make a letter, but you can use this process for any kind of document. Click the 'Mailings' tab in the ribbon and then click 'Start Mail Merge.' In the drop-down menu, choose 'Letters' or whatever other template you want to use. Position the cursor at the top left of the page, where you want the recipient's name and address to appear.Ĩ. Open a new, blank document and then create the boilerplate, common text you want to include in every mail merged document.ħ. You can save it anywhere, but you'll be able to find it more easily in Word if you save it in the 'DocumentsMy Data Sources' folder.Ħ. Then click the 'Home' tab and click 'General' in the Number section of the ribbon. To fix that, click the column header to select the entire column.

#Mailings tab in excel code#

For example, if the Zip Code column is formatted for numbers, zips with leading zeros will appear without the zero as a four-digit number. You might need to change the formatting of some columns. Ensure your data table is labeled with a header in the first row.Ĥ. Word will also use this row to import your data correctly. Label the header so you know what each column contains. If the data doesn't already have a header row, add one now (you can right-click Row 1 at the far left and choose 'Insert' from the menu). Import data into your spreadsheet or create it from scratch.ģ. Whatever method you need to use, get it into the spreadsheet. Click the 'Data' tab in the ribbon and choose 'Get Data,' then 'From File,' and finally 'From Text/CSV.' The data might also already be in an Excel spreadsheet, in an Access database, or you might need to type it into Excel from scratch. For example, if you have a large number of addresses stored in a CSV file, import it into this Excel file. You need to import or enter the data you plan to use, and how you do this depends on how the data currently exists.