Hi,

Within Excel, there is a Visual Basic function which allows you to sen
files to other individual users via E-Mail. This is done by using th
following VB Coding:

ActiveWorkbook.SendMail Recipients:="E-Mail Address"

However once the file is ready to send, a message box appears askin
you to confirm this action. Once you click the ok button, the file i
sent to the relevant recipient via e-mail.

I would, firstly, like to know whether or not the e-mail can be sen
automatically without having to confirm it.

I also have access to some PowerPoint presentations which are update
using macros located within Excel. The macro copies information fro
Excel, Opens PowerPoint and pastes the information into th
presentation. I would like to know whether or not it is possible t
write a similar macro to the one in Excel which will e-mail the update
PowerPoint file, which can be activated from Excel.

I have tried ActivePresentation but have been unsuccessful.

Any suggestions, tips and help would be appreciated. Thanks i
advance.

Kiz

--
Message posted from http://www.ExcelForum.com