Is there a way after macro runs to email.............

[mercmannick]

Is there a way that after a macro is run to send out by email just the updated sheet not entire workbook ?



Regards

Merc

[justme]

There is a lot of good information on code for sending mail from Excel at this site
http://www.rondebruin.nl/sendmail.htm

HTH

[mercmannick]

Justme

how do you code the line if u have 10-20 recipitents ?

Merc

[lucas]

mercmannick
If you go to the top of this page and click on kbase you will find many scripts that address emailing excel files and sheets. When you get to the kbase main page, click on search and search for mail or email. I saw three submissions there on the 1st part of the search return, probably more there. If you don't find what you need or you need help, post back here.

Here is a link to the knowledgebase search engine:
http://www.vbaexpress.com/kb/default.php?action=search

[Bob Phillips]

Justme

how do you code the line if u have 10-20 recipitents ?

Merc

Instead of using the To property, you could add Recipients, like so

.script12hide { display: none; }

Set oRecipient = OutMail.Recipients.Add("some.body@somewhere.com")
        oRecipient.Type = 1 '1 = To, use 2 for cc
                              'keep repeating these lines with
                              'your names, adding to the collection.

or you could create a distribution list and mail to that

[MOS MASTER]

how do you code the line if u have 10-20 recipitents ?

Hi,

Example 2 on this page:
http://www.rondebruin.nl/mail/folder1/mail2.htm

HTH,