vba courses london - excel automatically format sprea
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Excel Automatically to Format spreadsheet to e mail

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

resolvedResolved · Low Priority · Version Standard

replyReply Fri 24 Nov 2006, 10:41John (guest) said...

Excel Automatically to Format spreadsheet to e mail

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

For upcoming training course dates see: Pricing & availability

replyReply Fri 24 Nov 2006, 16:40 Edited on Fri 24 Nov 2006, 16:43Trainer Rich said...

RE: Excel Automatically to Format spreadsheet to e mail

Hi John,

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

Hope this helps.

Regards, Rich

 

Vba tip:

Good coding practice

It is important that you always comment the VBA code that you write. By doing this it will make the code much easier to read, as both yourself and other people will be able to see what the code is doing or meant to be doing. This is very important if there is more than one person who writes code in the company as you may have different styles of coding and may not really understand what the other person is trying to do. Also if you write some code and then do not touch it for a year or so you may actually forget what it is meant to be doing. so it is very important to include comments throughout your code and try and make sure that they are as useful as possible

View all VBA hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard