ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to copy active sheet and email to distribution list (https://www.excelbanter.com/excel-programming/366872-macro-copy-active-sheet-email-distribution-list.html)

bsnapool[_8_]

Macro to copy active sheet and email to distribution list
 

Hi wondering if anybody can help me with this one?

I'm looking at just copying the sheet, not the whole workbook of th
active sheet "masterentry" and emailing it to a selected distribio
list in selected cells.

anyone know how I could do this?

Thanks

Andrew :

--
bsnapoo
-----------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...fo&userid=3611
View this thread: http://www.excelforum.com/showthread.php?threadid=56015


Ron de Bruin

Macro to copy active sheet and email to distribution list
 
See
http://www.rondebruin.nl/sendmail.htm

Read also the tip link on each example page

--
Regards Ron de Bruin
http://www.rondebruin.nl



"bsnapool" wrote in message
...

Hi wondering if anybody can help me with this one?

I'm looking at just copying the sheet, not the whole workbook of the
active sheet "masterentry" and emailing it to a selected distribion
list in selected cells.

anyone know how I could do this?

Thanks

Andrew :)


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=560156





All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com