Send Email Macro Help

[Will03]

Hello,

I have a macro to send emails, that works fine but I need to make some changes and am looking for help with it.

What I need to accomplish is to send the email text to the employee and manager of the employee on the List Sheet by clicking the same button. Is that possible?

Can someone please help guide me in the right direction.

I have attached the file...

[swade730]

How did you design that cool "send email" button?

[jaslake]

Hi Will

Try this

Please Login or Register  to view this content.

[Will03]

Hello thanks for the prompt response jaslake, the code when I ran it just pops up one email which is to the last person on the list. It doesn't cycle through the list.

@swade730 its just a design option via the formatting toolbar

[jaslake]

Hi Will

I wouldn't send you something that was broken (at least not on purpose). See attached.

[Will03]

Hi jaslake... Thank you and what if needed to display each email as it scrolls through them and add a signature that is already established in my outlook?

[jaslake]

Hi Will

Signature can be added by Code...no need to

display each email as it scrolls through them and add a signature

Can't show you that now...Dinner Time...perhaps later tonight or tomorrow...

[Will03]

thanks jaslake... sorry I couldn't reply last nigh hope dinner was great... Ill continue to adapt the code and let you know asap how it goes.

[jaslake]

Hi Will

To insert your Signature in each Email, replace your Code with this Code. Change the indicated line to your Signature

Please Login or Register  to view this content.

[Will03]

THANKS FOR YOUR HELP!!! WORKS GREAT!!!! Specially the signature part that was awesome...

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.