Excel/PowerPoint E-Mails

[kiza]

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

 

[Bob Phillips]

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)

 

[Ron de Bruin]

Hi kiza

With Outlook or CDO you can send other files
But not with SendMail

For examples look here
http://www.rondebruin.nl/sendmail.htm

 

[Mestrella31]

Hi Kiza, sorry a cant't help you but you can help me, how did you trasfer the
data from Excel to Power Point?