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

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/

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"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/

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

"kiza " wrote:

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/