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

Resolved · Low Priority · Version Standard

Fri 24 Nov 2006, 10:41 John (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

Fri 24 Nov 2006, 16:40 Edited on Fri 24 Nov 2006, 16:43 Trainer 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Add A New Sheet at the end of the Workbook

To add a new sheet at the end of the workbook you need to count the sheets in the workbook using:

Sheets.Count

Then use this value as the rank of the sheet after which you want to add the new sheet:

Sheets.Add After:=Sheets(Sheets.Count)

View all VBA hints and tips