Copy in excel, paste in outlook, send automatically

[mjf1080]

Does anyone know how to copy a group of cells in Excel, paste those cells into a new email in outlook, and then send that email? I need to repeat this process every 15 minutes. Optimally I would like to be able to turn this feature on and off at will, so that it sends a new email every 15 minutes unless I tell it to stop.

Any help would be awesome.

 

[mvptomlinson]

The following site provides the code and information needed to send an e-mail containing a range of cells in the body of the message. You would then need to use an OnTime event to have it run every 15 minutes, and possibly add a button to pause the timer.

http://www.rondebruin.nl/mail/folder3/mail4.htm