Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
email merge

ResolvedVersion 2007

Keely has attended:
Word Intermediate course
Word Advanced course

Email merge

Hi,

Could you please tell me if it is possible to do an email merge from a list of email addresses and names? We want each email to look personalised with a Dear <name> and showing their email in the To: field rather than send a generic email with all the addresses in the bcc: field

Thanks

Keely

Edited on Fri 11 May 2012, 16:04

RE: Email merge

Hi Keely

Yes you can do an E-Mail merge using Word 2007. The message then appears personalized and doesn't require the use of bcc.

You'll need an Excel file with a list containing first name, last name and their e-mail address. Alternatively you can use Outlook Contacts.

Start with a blank document in Word
Click on the Mailing tab.
Select Start Mail Merge, Step by Step Mailmerge Wizard.
Select the option E-mail Messages.
Click Next twice.
At Step 3 browse to your Excel file (or choose Outlook Contacts)

At Step 4 start creating your message

Hi <firstname> (Click More Item... to add <firstname> field)

type your message and your
usual signature or way of ending an email.

At Step 5 preview your e-mail message.
At Step 6 click Electronic Mail.
Add a Subject for your meassage

Note: As soon as you press OK your message will be sent to
all recipients!

Hope that helps. You could practice by sending a message to doug@stl-training.co.uk using e-mail merge!

Regards
Doug Dunn
Best STL

Fri 18 May 2012: Automatically marked as resolved.

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.