Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel to outlook

	98.1 % recommend us
	More live stats...

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

Training information:

Excel to outlook

Resolved · Urgent Priority · Version 2007

Reply Thu 18 Nov 2010, 12:41Delegate Liz said...

Liz has attended:
SharePoint course

Excel to outlook

Hello
I have (or will have) an excel worksheet with a column of email addresses, one in each cell.
How can I best create an email distribution group for use in Outlook for a mailshot?
Thank you

For upcoming training course dates see: Pricing & availability

Reply Thu 18 Nov 2010, 17:30Trainer Simon said...

RE: excel to outlook

Hi Liz,

Thank you for your question.

You need to copy the email addresses in Excel, then open Outlook and create a new Distribution List.

Choose Select Members and paste (ctrl+v) into the members box and click OK.

I hope this answers your question.

Regards

Simon

Thu 25 Nov 2010: Automatically marked as resolved.

Excel articles

· Use Hyperlinks In Excel To Make An Impact
· Unsupported features in Excel 2007
· Improving Navigation Of Your Worksheets In Excel
· How to Create Better Excel Spreadsheets: Part Two
· Tools From Advanced Excel Courses: Goal Seek and Solver

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

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips