VBA for email

[Paul Norris]

Hi all

I am currently using a bsic code to email a workbook as shown below

Sub email()
ActiveWorkbook.SendMail Recipients:="email"
End Sub

This has been fine however my workbook has grown and is now to big, so to make things easier I am hoping to input a code were I can email just the sheet required this is named Updates, any advise will be appreciated.

Thanks
Paul

 

[VoG]

You should find some suitable code here http://www.rondebruin.nl/sendmail.htm

 

[jim may]

http://www.dicks-clicks.com/excel/olSending.htm


See 2nd Instruction (scroll down a bit) entitled: Sending One Sheet as an Attachment

 

[Paul Norris]

You should find some suitable code here http://www.rondebruin.nl/sendmail.htm

Sorry it took so long to reply to you been on holiday thanks for your assistance, tried but to no avail my mate was around and he managed to get it done for me. again thanks

 

[Paul Norris]

http://www.dicks-clicks.com/excel/olSending.htm


See 2nd Instruction (scroll down a bit) entitled: Sending One Sheet as an Attachment

Sorry it took so long to reply to you been on holiday thanks for your assistance, tried but to no avail my mate was around and he managed to get it done for me. again thanks