Mail merge from Excel to Outlook

The UK's most regular instructor-led training courses.
Training information: financial excel course london · Excel advanced · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · High Priority · Version 2007

1 post

ReplyThu 4 Feb 2010, 16:41Delegate Kaitlyn said...

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?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	2		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	8		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

331 posts

ReplyFri 5 Feb 2010, 17:17Trainer Anthony said...

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.

· Tips From Excel's 'Rarely Used' File
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· So what's new in Excel 2007?
· Easing the Transition to Excel 2007
· Say It With Ribbon

Please browse our web site to find out more about
financial excel course london and other Microsoft training courses.

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips