Mailmerge is a good way to make your mass-mailing seem more personal and appealing. It's not as difficult as you think, and it's a good skill to have.

A mail merge can be executed in the following steps.

In Outlook:

1. Go to “account settings” and set the desired address to send from as default.
2. In options, go to the tab “Mail” and tick “Always use the default account when composing new messages” under “Send messages”.
3. Close Outlook.

Then, in Word:

1. Under the tab “Mailings”, go to “Start Mail Merge” and select “E-Mail Messages”.
2. Go to “Select Recipients”, “Use an Existing List”, and load the sheet containing the data you want to merge on. Check if all data is correct by clicking “Edit Recipient List”.
3. Type your e-mail.
4. If you want to include a merge field, like a name to use when addressing the recipient, click on “Insert Merge Field” and select the field you want to include.
5. When you're done writing, click “Finish and Merge” to send the e-mail.
6. Fill in the e-mail subject, select the recipient e-mail field to merge on, if Word can't detect it automatically, and press “Ok”.
7. That's it!

Always send a test e-mail to yourself before you send out the entire batch, to check that the merged fields, addressing, and (in particular) the sending e-mail address are correct. Doing this is the only way to ensure that your e-mail will be sent correctly, such that you don't send a BarCo dinner invite to everyone from your personal e-mail, for example.