vba courses london - Email worksheet message body

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

Resolved · Low Priority · Version Standard

Email worksheet message body

Steven has attended:
Excel Advanced course
Excel Intermediate course

by - delegate Steven [2 posts] (2007 Feb 21 Wed, 15:20) Reply

Hi

How do I email a worksheet as the message body of an email using code?

Thanks
Steve

RE: email worksheet message body

by - trainer Jacob gold contributer [106 posts] (2007 Mar 1 Thu, 15:55) Reply

Hi Steve

Don't have a chunk of code to hand on this, I can check with my colleagues. Don't know if you have looked at our Excel VBA course that we run, this will give a good foundation to VBA code....

http://www.microsofttraining.net/excel-course-in-london-2003-vba.php

Rgds

Jacob

· Introduction to Visual Basic for Applications
· 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
· Visual Basic Returns To The Macintosh

Vba tip:

Use GoTo to Select A Cell With VBA

To select a certain cell on a Worksheet you can use:

Application.Goto Reference:=Range("V300")

or more simply

Range("V300").Select

If, on the other hand, you want the selected cell to be the top/left cell on the screen you use:

Application.Goto Reference:=Range("V300"), Scroll=True

View all VBA hints and tips