If you have Outlook, you could post it through Outlook after saving it. Do
you?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"kiza " wrote in message
...
Hi,

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

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

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

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

I also have access to some PowerPoint presentations which are updated
using macros located within Excel. The macro copies information from
Excel, Opens PowerPoint and pastes the information into the
presentation. I would like to know whether or not it is possible to
write a similar macro to the one in Excel which will e-mail the updated
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 in
advance.

Kiza


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