Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Vba send an email

	98.1 % recommend us
	More live stats...

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

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Vba send an email

Resolved · Low Priority · Version 2003

Reply Thu 7 Aug 2008, 16:30Delegate Emma said...

Emma has attended:
Excel VBA Intro Intermediate course

Vba send an email

how do i send an email with vba?

For upcoming training course dates see: Pricing & availability

Reply Mon 15 Sep 2008, 14:19Trainer Carlos said...

RE: vba send an email

Hi Emma

If you wish to email the current workbook to a colleague or anyone else then the following line of code will do exactly that:

ActiveWorkbook.SendMail Recipients:="theirname@theircompany.com", _
Subject:="Latest Accounts"

This creates a new e-mail with the above address and Subjent line and the workbook attached.

Hope this helps

Carlos

Excel articles

· Where Are The Form Controls In Different Versions Of Excel
· The Secret Formula To Creating Correct Calculations In Excel
· That's The Wonder Of Autofill
· How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010
· Learn How To Chart Your Deeper Data

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

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips