how to do a mail merge with word and excel for mac

Say pages one and two of the print have text, but page three has nothing on it.

This is useful when personalizing newsletters or statements, as you dont have to write by hand each persons name or address at the top of each document.

Microsoft Excels app icon resembles a white X on a dark-green background.

Starting in cell A1 and moving right from there, enter the following headers: 1.

Starting in column A, cell 2, begin entering the contact information for each of the people for whom you want to generate a mail merge.

You can now proceed to creating the mail merge in Microsoft Word.

The Word app icon looks like a white W on a dark-blue background.

This is useful when you only need to create a handful of contacts information.

On the left side of the window, click the folder in which you saved the Excel sheet, then click the Excel sheet to select it.

Click the Excel sheets name in the pop-up window, then click OK at the bottom of the window.

Your Excel sheet will be selected as the location from which your contacts will load.

Find the place where you want to insert contact information (e.g., the top of the document) and click it to place the cursor there.

Its an option in the Write Insert Fields section of the Mailings tab.

In the drop-down menu, click the name of one of the headers from your Excel document to insert it.

This might include contacts addresses, last names, phone numbers, and so on.

Depending on your selected option, you will have an additional form to review (for example, if you selected Email, youll have to enter a subject and then click OK ).

Then select recipients and either make a list, or find a file if you already made one by choosing Use existing list.

Type your letter, and press Add merge field whenever you need to use something from your list.

Make any additional changes needed, and press Finish and merge, and then print if you need to.

Remember to re-select all of the ones you need after you make your changes.

For example, after you click Print, you will get a preview of your document.

How To Do A Mail Merge With Word And Excel For Mac