how to make mailing labels in word for mac from excel spreadsheet

Make Mailing Labels In Word From Excel Spreadsheet Install This Add

You can also assign the shortcut key to this macro if required.

Lets say you have data in Excel file, and you want to create multiple Word documents from that, each individualized based on data from Excel, then this tutorial will help you do that.

You can merge the information from Excel Sheet to Word document with few clicks.

This tutorial explains two simple methods about How to mail merge from Excel to Word.

In case you add new records to Excel, then you can run mail merge on only those records as well by just providing start and end number of the records.

You can follow the below steps to create a mail merged document from Excel to Word.

Now from various options, choose Step-by-Step Mail Merge Wizard from the list as shown in the below screenshot.

In this case, I am selecting Letters (step 1 of 6) and click Next button.

A new dialog box will open and here you can browse for a database file (Excel File).

Now select the desired sheet (if more than one sheets are present in the Excel file).

Choose the desired field and click it to place at the current cursor location.

After that, you can Merge the Final Document to Printer, Edit Individual Documents, andor Send Email Messages to the respective persons by clicking the Finish Merge button as shown.

To do this, open the main document whom you want to use for Mail Merge.

Now at top of the page apply Heading 1 to the First word or few words.

In this case, I applied Heading 1 to Dear, because I want to save each document with different name automatically.

Now from Mailing Tab, use the mail merge function and create a new Master Document (combined document).

A ll the letters will be saved in the same location with different names in split documents separately.

Make Mailing Labels In Word From Excel Spreadsheet Install This Add

Just download and install this Add-in by following the instructions.

Now run the MS Word and create your main document as stated in the above How to Mail Merge from Excel to Word tutorial.

Now click the Merge Split button of this Add-in on Mailings Menu.

Now choose DOCX or DOC from the Documents Options section and click Split to Documents.

Now all the splitted documents will be saved in the location of your choice with different names.

Now open MS Word and press AltF11 key from your keyboard to open the Words own Visual Basic editor.

Now Press AltF8 and select BreakOnPage macro from the list and click Run button.

How To Make Mailing Labels In Word For Mac From Excel Spreadsheet