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

Do A Mail Merge With Word And Excel For Free By Whitelisting

To create this article, 23 people, some anonymous, worked to edit and improve it over time.

Well outline a much more linear process -- creating an address file in Excel, merging in Word, and adding intents and finer details.

This is normally First Name, Last Name, Street Address, City, county, Postal code.

Ignore the fact that they all end up on a single line, when youre done selecting you can add spaces and carriage returns where you want them on the label.

If you forget one place the cursor where you want it to go (the field to the right of the cursor will probably turn graythats OK), then click on More items.

Click CLOSE on the window once you have finished inserting all the fields you require.

Ignore it when the field after the location for either one turns grey the space will be added instead of replacing the field.

Try placing a singe quote mark at the start of the ZIP code andor reformatting the cell to text.

By continuing to use our site, you agree to our cookie policy.

Do A Mail Merge With Word And Excel For Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

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