The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Outlook Training and help » Mailmerge Excel - Outlook

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Mailmerge Excel - Outlook

Resolved · Low Priority · Version 2007

ReplyFri 26 Feb 2010, 14:16Delegate Kate said...

Mailmerge Excel - Outlook

Please can you instruct me on how to set up a mailmerge from an Excel distribution list into an email send out in Outlook. The aim would be that Outlook would pick up the email address from Excel to send the email to and then the first name so that each email would be individually addressed.
Thanks
Kate

For upcoming training course dates see: Pricing & availability

ReplyMon 1 Mar 2010, 13:51Trainer Anthony said...

RE: Mailmerge Excel - Outlook

Hi Kate, thanks for your query. First click Tools-Options-Mail Format and then make sure that "Use Microsoft Office Word 2003 to edit emails" is checked. Click OK.

Then, create a new email and click into the body of the email. Select Tools, Letters and Mailings, Mail Merge. Follow the wizard and you can choose your Excel spreadsheet as your source of recipients in step 3 of the wizard.

Hope this helps,

Anthony

ReplyTue 2 Mar 2010, 10:15Delegate Kate said...

RE: Mailmerge Excel - Outlook

Hi Anthony,

When I go into Tools-Options-Mail Format I can't see a place or option for "Use Microsoft Office Word 2003 to edit emails".

I'm working from 2007 if that changes anything.

i've taken a screen shot but can't upload it into this email for you to see.

Thanks
Kate

ReplyMon 8 Mar 2010, 11:53Trainer Anthony said...

RE: Mailmerge Excel - Outlook

Hi Kate. It's slightly different in 2007. Do the e-mail merge from withing Word itself using the step by step wizard. It will give you the option to merge to emails and you browse to the Excel file for your contacts in the usual way.

Let me know how you get on!

Anthony

Outlook articles

· Applying Colour Coding In Microsoft Outlook
· How Can Outlook Help Keep Your Business Secure?
· Microsoft Outlook offers you much more than email functions
· How To Create Your Own Custom Folders Within Outlook
· How To Get Outlook 2007 Up To Maximum Speed

Please browse our web site to find out more about
microsoft outlook courses and other Microsoft training courses.

Outlook tip:

Set Outlook to automatically save Unsent messages

In Outlook, you can automatically save unfinished messages in your 'Drafts' folder.

Click the 'Tools' menu, then select 'Options'.
Click 'Email options' and select the 'Automatically save unsent messages' option.

Your draft emails will now be saved every 3 minutes. If you want to save an email more often than that, just click 'Save' at any time.

View all Outlook hints and tips

The Five Steps Every Training Company Should Follow

How can you tell a good training company from a bad one? Any decent training provider will follow these five steps - so what are they?

» Article: Training company london

How do i duplicate a graphic quickly?

» Forum post: Powerpoint

If you want to create a bulleted or numbered list in Word, you can do so without using the bulleting or numbering buttons on the toolbar.

Here's how:

To start a bulleted list:
Type in an asterisk (*) or a hyphen (-) followed by a space then your te...