ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Create Object for MS Mail (https://www.excelbanter.com/excel-programming/420423-create-object-ms-mail.html)

OssieMac

Create Object for MS Mail
 
I use the following to create an object for Outlook.

Dim OutlookApp As Object
Set OutlookApp = CreateObject("Outlook.Application")

What is the syntax to do the same for Microsoft Mail (As supplied with
windows Vista)

I am using xl2007.


--
Regards,

OssieMac

Ron de Bruin

Create Object for MS Mail
 
Hi OssieMac

I think you want to say Windows Mail
There is no object model for Windows Mail

But you SendMail to send mail with this program
See http://www.rondebruin.nl/sendmail.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"OssieMac" wrote in message ...
I use the following to create an object for Outlook.

Dim OutlookApp As Object
Set OutlookApp = CreateObject("Outlook.Application")

What is the syntax to do the same for Microsoft Mail (As supplied with
windows Vista)

I am using xl2007.


--
Regards,

OssieMac


OssieMac

Create Object for MS Mail
 
Hi Ron,

Yes. I did mean Windows Mail. My son always tells me "Another Seniors Moment".

Really appreciate your help. Your examples have answered my question
perfectly.


--
Regards,

OssieMac


"Ron de Bruin" wrote:

Hi OssieMac

I think you want to say Windows Mail
There is no object model for Windows Mail

But you SendMail to send mail with this program
See http://www.rondebruin.nl/sendmail.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"OssieMac" wrote in message ...
I use the following to create an object for Outlook.

Dim OutlookApp As Object
Set OutlookApp = CreateObject("Outlook.Application")

What is the syntax to do the same for Microsoft Mail (As supplied with
windows Vista)

I am using xl2007.


--
Regards,

OssieMac




All times are GMT +1. The time now is 10:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com