| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sheets 2,3,4,5 ect. to users from a list on sheet1
I am trying to write a macro (with no success) to email multiple sheets to multiple users. When the user clicks Email button a macro should go through the avalable sheets and email each sheet to the owner. Ie.. The 401-K sheet should only be sent to and so on I am using Outlook as the mail client Thanks for any help I am really stuck. +-------------------------------------------------------------------+ |Filename: email-books.zip | |Download: http://www.excelforum.com/attachment.php?postid=3475 | +-------------------------------------------------------------------+ -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email sheets 2,3,4,5 ect. to users from a list on sheet1
Hi
Look on my site for examples http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "swieduwi" wrote in message ... I am trying to write a macro (with no success) to email multiple sheets to multiple users. When the user clicks Email button a macro should go through the avalable sheets and email each sheet to the owner. Ie.. The 401-K sheet should only be sent to and so on I am using Outlook as the mail client Thanks for any help I am really stuck. +-------------------------------------------------------------------+ |Filename: email-books.zip | |Download: http://www.excelforum.com/attachment.php?postid=3475 | +-------------------------------------------------------------------+ -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email sheets 2,3,4,5 ect. to users from a list on sheet1
Thanks for the Relpy Ron de Bruin The URL you provided is not workin -- swieduw ----------------------------------------------------------------------- swieduwi's Profile: http://www.excelforum.com/member.php...fo&userid=2196 View this thread: http://www.excelforum.com/showthread.php?threadid=37809 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email sheets 2,3,4,5 ect. to users from a list on sheet1
Try it again, it is working
-- Regards Ron de Bruin http://www.rondebruin.nl "swieduwi" wrote in message ... Thanks for the Relpy Ron de Bruin The URL you provided is not working -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email sheets 2,3,4,5 ect. to users from a list on sheet1
Sorry, sir, still nothing is there a way you can post examples here :) when I try to ping it get "Unknown host" -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email sheets 2,3,4,5 ect. to users from a list on sheet1
Hi
is there a way you can post examples here To much there If you click on this link is it working then http://www.rondebruin.nl/ -- Regards Ron de Bruin http://www.rondebruin.nl "swieduwi" wrote in message ... Sorry, sir, still nothing is there a way you can post examples here :) when I try to ping it get "Unknown host" -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data in sheet1 to be put into sheets 2, 3, 4, 5, etc | Excel Discussion (Misc queries) | |||
| VBA Code Required for deleting All Sheets except Sheet1 | Excel Discussion (Misc queries) | |||
| Can I email unique worksheets from a workbook to different users? | Excel Discussion (Misc queries) | |||
| How do I set up a workbook so changing Sheet1 changes all sheets? | Excel Worksheet Functions | |||
| copy sheet1 and name sheets using names from a range | Excel Programming | |||
Hybrid Mode
