Compose Personalized Emails

[Twitter]

You have an invitation to e-mail to many people? With Excel, Word and Outlook present in the Microsoft Office suite, you can easily make a nice custom e-mailing. Each e-mail and will be automatically addressed and personalized with the recipient's information.

Thus, Excel will allow you to establish the list of recipients with various information that you will be able to reuse your personal e-mail: Name, e-mail address and any other information you may need.

With Word, you will be able to write and format your message with the many tools of word processing: color, page background, images, etc.. With the mail merge feature, you can link your list of recipients made with your Excel document. To customize your message with your contact information, you can insert fields that will contain the information of your contacts.

Finally, you have to do all that automatically send personalized messages with your Outlook mail.

Create your contact list:
With Excel, you can easily create a list of people you want to send your personalized e-mailing.

1. In Excel, create a column for each information about your contacts. For example, create the columns Name, First Name and Email.
   
2. Put these bold columns for emphasis.
   
3. Then fill the columns with information of people you want to send your personalized e-mailing.
   
4. Save your workbook at last.

Create document:

In Word, you can now write your message using all the tools layout of word processing.

1. You can format your text by changing the font and color used.
   
2. To choose a background color, open the Layout tab and click Page Color. You can choose the color to be applied in the background, but if you prefer a texture image.
   
3. To insert images, open the Insert tab and click Clip Art. Then look in the right pane of the images that match your criteria.
   
4. When you've spotted an image corresponding to your search, click where you want to insert, then double-click on the image.
   
5. In the Organize area of the Layout tab, click Text Wrapping then Square.
   
6. Now you can position your image where you want. Click on it and move it by dragging and dropping.
   
7. Save your document.

[Twitter]

Create mail:

The goal is to connect a mailing list of contacts and a document that you want to convey to these contacts. It allows you to insert fields to customize your message.

1. In Word, open the Mailings tab.
   
2. Start the Mail Merge Wizard and then click Mail Merge step.
   
3. Select mail messages and click Next.
   
4. Select Use the current document and click Next.
   
5. Select Use an existing list in the Select Recipients then click Browse.
   
6. Select your Excel file containing your address list and click Open.
   
7. Select the first sheet of your workbook and click OK.
   
8. The list of contacts is displayed. Uncheck the box in front of people not involved in the mailing and click OK.
   
9. Click Next.

Merge information:

To customize your message, you can insert fields that will contain the information of your contacts.

1. In the right pane, the fields are available: address block, greeting line. For more options, click More items.
   
2. The list of headers in your table of contacts is displayed. These headers are fields. If you insert the Name field, each message will display instead of name, the real name for the recipient and from your table. Click the one you want then click the Insert button. Repeat as many times as necessary and then click Close.
   
3. Then place these fields in the right places in your document. They will be replaced by their true values when sending.
   
4. Click Next. A preview of your message is displayed.
   
5. You can check the result for each recipient using the navigation arrows. The fields you have inserted are replaced by the names of recipients.

[Twitter]

Send messages:

Finally, you have to do all that automatically send personalized messages with your Outlook mail.

1. Click Next and then click E-mail.
   
   
2. Click on the dropdown menu A, then the title of the column containing the e-mail addresses.
   
   
3. Click in the Subject field and enter the subject of your message.
   
   
4. Click OK. Your messages go instantly. You will find them in the Sent Items folder of your email.