ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA code to send range automatically via email (https://www.excelbanter.com/excel-programming/302806-vba-code-send-range-automatically-via-email.html)

carl

VBA code to send range automatically via email
 
I have a spreadsheet that updates automatically. I need
to send this information every hour to text pagers. I
cannot send the workbook as an attachment. I want to send
only the information within a specified range.

keepITcool

VBA code to send range automatically via email
 

Carl..

Hope you weren't expecting some ready to run code.
Sites listed come highly recommended and include lots of code samples.


procedure scheduling with ontime:
http://www.cpearson.com/excel/ontime.htm

emailing with excel:
http://www.rondebruin.nl

you'll need to download a tool called redemption to
'prevent outlook preventing' programmatic emailing.
http://www.dimastr.com/redemption/


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Carl" wrote:

I have a spreadsheet that updates automatically. I need
to send this information every hour to text pagers. I
cannot send the workbook as an attachment. I want to send
only the information within a specified range.




All times are GMT +1. The time now is 01:28 PM.

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