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.

Hi Spoonerstreet

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

--

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


"Spoonerstreet" wrote in message ...
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.

On Oct 17, 3:23*pm, "Ron de Bruin" wrote:
Hi Spoonerstreet

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

--

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

"Spoonerstreet" wrote in ...
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.

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?

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


"Spoonerstreet" wrote in message ...
On Oct 17, 3:23 pm, "Ron de Bruin" wrote:
Hi Spoonerstreet

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

--

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

"Spoonerstreet" wrote in ...
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.

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?

On Oct 17, 4:04*pm, "Ron de Bruin" wrote:
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

"Spoonerstreet" wrote in ...

On Oct 17, 3:23 pm, "Ron de Bruin" wrote:



Hi Spoonerstreet

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

--

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

"Spoonerstreet" wrote in ...
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.

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. :)

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


"Spoonerstreet" wrote in message ...
On Oct 17, 4:04 pm, "Ron de Bruin" wrote:
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

"Spoonerstreet" wrote in ...

On Oct 17, 3:23 pm, "Ron de Bruin" wrote:



Hi Spoonerstreet

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

--

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

"Spoonerstreet" wrote in
...
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.

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. :)

On Oct 17, 4:15*pm, "Ron de Bruin" wrote:
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

"Spoonerstreet" wrote in ...

On Oct 17, 4:04 pm, "Ron de Bruin" wrote:



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

"Spoonerstreet" wrote in ...

On Oct 17, 3:23 pm, "Ron de Bruin" wrote:

Hi Spoonerstreet

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

--

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

"Spoonerstreet" wrote in
...
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.

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. :)

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