mail merge excel outlook

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

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

Mail merge from Excel to Outlook

resolvedResolved · High Priority · Version 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:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips


Server loaded in 0.08 secs.