| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I mail from a list on excell | Excel Discussion (Misc queries) | |||
| Alpha sort excel mail list | Excel Discussion (Misc queries) | |||
| .txt file to mail list (excel best option) | New Users to Excel | |||
| mail merge- & data source - only taking 1st name in the list | Excel Discussion (Misc queries) | |||
| Is there a template to compile a list of users for multiple accou. | Excel Discussion (Misc queries) | |||
Linear Mode
