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

mail merge excel outlook

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Mail merge from Excel to Outlook

Mail merge from Excel to Outlook

ResolvedVersion 2007

Kaitlyn has attended:
Excel Intermediate course
Excel Advanced course

Mail merge from Excel to Outlook

How can you create an email mail merge using an excel spreadsheet as the source?

RE: Mail merge from Excel to Outlook

Hi Kaitlyn, thanks for your query. The answer depends a lot on the situation and there are several possible solutions. Do you want to mail merge into the content of an email or send 100 emails out using a list of addressees in an Excel spreadsheet? If the latter, you need to import the address list into Outlook to create an email group and then use that to email to the addressees. On the other hand, if it's the content you want to merge from Excel, the body of an email can be an HTML document. You could carry out a mail merge to Word and then save the documents out as HTML documents, using them as the body of your emails.

I hope this helps, but if you've got any more information do let me know.

Anthony

Fri 12 Feb 2010: Automatically marked as resolved.

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

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.1 secs.