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 Excel Training and help » Word and Outlook and Excel

	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:

Word and Outlook and Excel

Resolved · Medium Priority · Version 2007

ReplyWed 1 Jul 2009, 16:17Delegate Fiona said...

Word and Outlook and Excel

Is it possible to mail merge an e-mail with an attachment?
if so how?

For upcoming training course dates see: Pricing & availability

ReplyThu 2 Jul 2009, 09:35Trainer Amanda said...

RE: Word and Outlook and Excel

Hello Fiona

Thank you for your question.

I think this would be possible, if you started a new email message, attached the file, then followed through the mail merge process (instructions attached) in Outlook. You would need to have Word set as your email editor in Outlook for this to work.

Kind regards
Amanda

Attached files...

Main Merge From Excel To E-Mail.doc

ReplyThu 2 Jul 2009, 11:48Delegate Fiona said...

RE: Word and Outlook and Excel

Hi Amanda,
thank you for this, however could you send instructions for 2007?
Thanks
Fi

ReplyThu 2 Jul 2009, 13:27Trainer Amanda said...

RE: Word and Outlook and Excel

Hi Fiona

I don't have any written instructions for 2007, however the process will be pretty much the same...if Word is set as your email editor, do you have a Tools tab available within the email when you start a new mail message? If so then it should have the Letters and Mailing button or something similar that would launch the Mail Merge Wizard for you.

Kind regards
Amanda

ReplyThu 16 Jul 2009, 13:33Delegate Fiona said...

RE: Word and Outlook and Excel

Sorry for the delay in responding, we have tried this, but have been unable to set this up.

ReplyFri 17 Jul 2009, 17:24Trainer Amanda said...

RE: Word and Outlook and Excel

Hi Fiona

I'll have to have a look into this in a bit more detail next week, I'll see what I can come up with and respond to you again, hopefully with something useful!

Kind regards
Amanda

ReplyMon 20 Jul 2009, 15:33Trainer Amanda said...

RE: Word and Outlook and Excel

Hello Fi

I've had a bit more of a look into this for you, it seems that creating an email mail merge with an attachment in Outlook 2007 is not as straightforward as in the 2003 version.

I could only find instructions for creating a mail merge in Outlook without an attachment (below):
http://www.howto-outlook.com/howto/mailmerge.htm

It seems that if you would like to include an attachment with the mail merge, this requires VBA coding or using a third-party add-in (see link below):
http://www.outlook-tips.net/archives/2007/20070209.htm

Kind regards
Amanda

Mon 27 Jul 2009: Automatically marked as resolved.

Excel articles

· How To Link Between Spreadsheets In Excel
· Using Excel In Any Condition
· Backstage Management With Excel 2010
· From the Classroom to the Corporate World
· Discover The Secret Of How To Conditionally Format An Excel Chart

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

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

I would like to deduct the value of one field from another in a query. The information is in two different tables within the query.
How do I do this???

Regards,