View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Timothy.Rybak@gmail.com is offline
external usenet poster
 
Posts: 11
Default Help emailing worksheet range via Redemption

I am trying to automate an Excel macro so that it will run its update
and email the results without any user intervention. I have installed
Redemption, and I can successfully send a test mail. The problem that
I am having is that I cannot figure out how to send a worksheet, or a
range from a worksheet. I can only send hard coded text. What do I
need to put in the safeitem.body statement to send, say:

Sheets("Sheet1").Range("A1:C10")

Thanks!
Tim