Vba send an email

Resolved · Low Priority · Version 2003

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

Emma has attended:
Excel VBA Intro Intermediate course

Vba send an email

how do i send an email with vba?

Mon 15 Sep 2008, 14:19 Trainer 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 tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips

Vba send an email

Vba send an email

RE: vba send an email

Excel articles

Excel tip:

Fill formulae across a sheet