Send different worksheets to different email addresses

S

Spoonerstreet

I have a set of Workbooks, each with multiple worksheets.

Each worksheet represents the tracking of a particular person. I
would like to set up a macro that will send THAT worksheet to THAT
person.

For example, I have a workbook with the tabs "Steve", "Mary", and
"John.

I would like to click one button and have it send an email to Steve
with his sheet, Mary gets a separate email with just her sheet, and
John gets one as well.

How can I put their email address into the page and have Excel send
the email out with the sheet in the body of the page so they can
receive updates to their pages without printing?

Thanks!

Excel 2003, btw.
 
S

Spoonerstreet

Hi Spoonerstreet

Maybe you can use thishttp://www.rondebruin.nl/mail/folder3/mail5.htm

Ron, first of all, let me apologize. I just sent you about 15 messages
while testing out the code. Sorry about that!

Second, it worked great, except it didn't seem to send it to the
address that is in A1. It appears in the code that it is supposed to
go to a hard coded address. Am I missing something, or did I copy the
wrong code?
 
R

Ron de Bruin

No it use the address in A1 but you can change that cell address if you want

Do you use the example from the page I posted ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Hi Spoonerstreet

Maybe you can use thishttp://www.rondebruin.nl/mail/folder3/mail5.htm

Ron, first of all, let me apologize. I just sent you about 15 messages
while testing out the code. Sorry about that!

Second, it worked great, except it didn't seem to send it to the
address that is in A1. It appears in the code that it is supposed to
go to a hard coded address. Am I missing something, or did I copy the
wrong code?
 
S

Spoonerstreet

No it use the address in A1 but you can change that cell address  if you want

Do you use the example from the page I posted ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm






Ron, first of all, let me apologize. I just sent you about 15 messages
while testing out the code. Sorry about that!

Second, it worked great, except it didn't seem to send it to the
address that is in A1.  It appears in the code that it is supposed to
go to a hard coded address.  Am I missing something, or did I copy the
wrong code?

Copied it line by line. If you look at the page, the "To:" address is
hardcoded to your email address. I figured this is supposed to be
some kind of dynamic reference, but my VB knowledge isn't up to par to
figure that out. :)
 
R

Ron de Bruin

Hi Spoonerstreet

You not test the code I posted

This is the link again
http://www.rondebruin.nl/mail/folder3/mail5.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


No it use the address in A1 but you can change that cell address if you want

Do you use the example from the page I posted ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm






Ron, first of all, let me apologize. I just sent you about 15 messages
while testing out the code. Sorry about that!

Second, it worked great, except it didn't seem to send it to the
address that is in A1. It appears in the code that it is supposed to
go to a hard coded address. Am I missing something, or did I copy the
wrong code?

Copied it line by line. If you look at the page, the "To:" address is
hardcoded to your email address. I figured this is supposed to be
some kind of dynamic reference, but my VB knowledge isn't up to par to
figure that out. :)
 
S

Spoonerstreet

Hi Spoonerstreet

You not test the code I posted

This is the link againhttp://www.rondebruin.nl/mail/folder3/mail5.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm









Copied it line by line.  If you look at the page, the "To:" address is
hardcoded to your email address.  I figured this is supposed to be
some kind of dynamic reference, but my VB knowledge isn't up to par to
figure that out. :)

Ah...I see where I went wrong. I must have moved back to your main
page and clicked on a similar but different link.

This worked (as I am sure you know) brilliantly! Thanks for the code,
and keep up the great work. You are making us all look like geniuses!

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top