vba courses london - Excel Automatically to Format spreadsheet to e mail

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Excel Automatically to Format spreadsheet to e mail

by - John [guest] (2006 Nov 24 Fri, 10:41) Reply

I would like to know how to run a script so that spreadsheets are then attached to relevant e mail adresses

I want to be able to send reports out to different area managers without needing to do it manually.

Thanks
John

RE: Excel Automatically to Format spreadsheet to e mail

by - trainer Rich platinum contributer [744 posts] (2006 Nov 24 Fri, 16:40) Edited on 2006 Nov 24 Fri, 16:43 Reply

Hi John,

The answer to your question is the same as Aman's question last week, found here.

Hope this helps.

Regards, Rich

· Visual Basic Returns To The Macintosh
· Should You Send Managers To VBA Training?
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· How To Find A Good VB For Access Trainer
· Company Roles in Visual Basic Training

Vba tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips