E-mail from list of users
 

Morning,

I have a spreadsheet that is completed by a contract manager (CM) and then
sent to his/her respective regional manager (RM).
I have a list of contract managers/ depot per regional manger.
I want the CM to click on a macro button that will automatically send his
spreadsheet to his/ her respective RM.
So far I can get the Send To working but then it does not paste the RM into
the 'TO' box on the e-mail.
This has to be done manually when I run the macro.

Any suggestions?

Thanks

E-mail from list of users
 

Check out this site for sending mail

http://www.rondebruin.nl/sendmail.htm
--
Hth

Kassie Kasselman


"Sunnyskies" wrote:

Morning,

I have a spreadsheet that is completed by a contract manager (CM) and then
sent to his/her respective regional manager (RM).
I have a list of contract managers/ depot per regional manger.
I want the CM to click on a macro button that will automatically send his
spreadsheet to his/ her respective RM.
So far I can get the Send To working but then it does not paste the RM into
the 'TO' box on the e-mail.
This has to be done manually when I run the macro.

Any suggestions?

Thanks

E-mail from list of users
 

Testing with some mods thanks

"kassie" wrote:

Check out this site for sending mail

http://www.rondebruin.nl/sendmail.htm
--
Hth

Kassie Kasselman


"Sunnyskies" wrote:

Morning,

I have a spreadsheet that is completed by a contract manager (CM) and then
sent to his/her respective regional manager (RM).
I have a list of contract managers/ depot per regional manger.
I want the CM to click on a macro button that will automatically send his
spreadsheet to his/ her respective RM.
So far I can get the Send To working but then it does not paste the RM into
the 'TO' box on the e-mail.
This has to be done manually when I run the macro.

Any suggestions?

Thanks