Simple Tips On How To Email Merge

You’ve been assigned to send the entire company staff with the next meeting notice in their email address and no idea what to do? Thanks for the email merge. This will help you send all the emails to everyone in a single click; sounds impressive! I am sure yes, it’s simple with tricks on how to email merge. To help you communicate with them using a single click, here are some tips that you should follow when email merging.

Email Merging Guide

Open MS Excel

MS Excel’s an app in your pc with an icon in white (depending on your display) with ‘X’ on a dark green background. When you open excel, blank page will appear. If it displays the contact sheet ready, then you can skip into the importing contact icon instead.

Open Blank workbook

The icon is in the upper left corner in your pc on top of the new page clicking. This will help you get a new excel page. On top right corner insert number of the emails and click enter

Add contact headers

A1 being your first header move right then click add and add the following details;

Name (First) — your contacts (receiver) will display in the A1 column.
Name (last) – Your receiver/ contact names will display in B1 column
Address, telephone, cellphone- your contact address, telephone, and the cellphone will display in C1 column
City/state/zip- You contact Zip will display on D1, E1, F1, G1, respectively.
Email- Your receivers email address will display in H1 column

Enter contacts’ information

With column A1 cell number 2 being your starting column, start entering the valid email information for each of the staff for whom you wish to generate the how to email merge. Ensure that this information is right; you can counter check to be accurate. Because if one of the address bounces back, it means they all the mail will not send. To avoid this counter check and be sure that what you have typed is correct.

Save your doc

This depends on the type of the operating system you are using if you are a windows person, click File and then save as right-clicking choose the storage location then ok. For mac book, the process is still the same.

Click mailings tabs

Open a new page in word, then click n millings, then import contacts from excel and deduce the subject to your email then type the information you wish to pass. This is the last part of your work you can save for reference if needed. Click Ok to send he Emails.

Leave a Reply

Your email address will not be published. Required fields are marked *