| 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 |
| 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 | |||
Threaded Mode
