send mail without outlook

[x taol]

I have outlook application.
How can I know what sending mail without outlook?

 

[JLGWhiz]

Not really sure what you are asking, but you can set up a free mail account
with Yahoo. If you have AOL, they have a mail service. There are several
out there if you check around. If you mean how to send mail from Excel or
VBA for other than Outlook, then that is a different story.

 

[JLGWhiz]

This from Excel help files.

To send e-mail from Excel To send data as an attachment, you need
Microsoft Outlook, Microsoft Outlook Express, Microsoft Exchange Client, or
another 32-bit e-mail program compatible with the Messaging Application
Programming Interface (MAPI). Make sure Mapi32.dll is in the Windows System
folder. To send Excel data as the body of a message, you need Outlook 2000 or
later.

 

[Ron de Bruin]

Or use CDO
http://www.rondebruin.nl/cdo.htm

 

[Angus]

Hi Ron,

I have been using your codes for years, they are fabulous. Thank you very
much.

Until last month when I change to a new company using Microsoft Exchange
Server. I cannot send anymore Excel with attachment by CDO. I had gone
through your website just want to confirm again that CDO doesn't support
Exchange Server (and only smtp)? that means I have to use click-it at
outlook? But I got hundreds of email to send everyday.

An option is use gmail, and I did. But the sender becomes "Angus
Casey[[email protected]]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
[[email protected]]" even I send it via smtp.gmail.com?

Angus

 

[Ron de Bruin]

Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" <[email protected]>"

--

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

Hi Ron,

I have been using your codes for years, they are fabulous. Thank you very
much.

Until last month when I change to a new company using Microsoft Exchange
Server. I cannot send anymore Excel with attachment by CDO. I had gone
through your website just want to confirm again that CDO doesn't support
Exchange Server (and only smtp)? that means I have to use click-it at
outlook? But I got hundreds of email to send everyday.

An option is use gmail, and I did. But the sender becomes "Angus
Casey[[email protected]]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
[[email protected]]" even I send it via smtp.gmail.com?

Angus

Or use CDO
http://www.rondebruin.nl/cdo.htm

 

[Angus]

Yes, I use .Form = """Ron""<[email protected]>", but when the excel is sent
via smtp.gmail.com, the receipt will be "Ron <[email protected]>". Can
I make it appear "Ron <[email protected]>"?

Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" <[email protected]>"

--

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

Hi Ron,

I have been using your codes for years, they are fabulous. Thank you very
much.

Until last month when I change to a new company using Microsoft Exchange
Server. I cannot send anymore Excel with attachment by CDO. I had gone
through your website just want to confirm again that CDO doesn't support
Exchange Server (and only smtp)? that means I have to use click-it at
outlook? But I got hundreds of email to send everyday.

An option is use gmail, and I did. But the sender becomes "Angus
Casey[[email protected]]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
[[email protected]]" even I send it via smtp.gmail.com?

Angus

Or use CDO
http://www.rondebruin.nl/cdo.htm

--

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


This from Excel help files.

To send e-mail from Excel To send data as an attachment, you need
Microsoft Outlook, Microsoft Outlook Express, Microsoft Exchange Client, or
another 32-bit e-mail program compatible with the Messaging Application
Programming Interface (MAPI). Make sure Mapi32.dll is in the Windows System
folder. To send Excel data as the body of a message, you need Outlook 2000 or
later.



:

I have outlook application.
How can I know what sending mail without outlook?

 

[Angus]

Hi Ron, i want to edit my reply a little bit for not to confuse you.
I use

with iMsg
..Form = """Ron""<[email protected]>"

but when the excel is sent via smtp.gmail.com, the sender will be "Ron
<[email protected]>". I want to make it appear like "Ron
<[email protected]>" but not my gmail address?

Angus

Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" <[email protected]>"

--

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

Hi Ron,

I have been using your codes for years, they are fabulous. Thank you very
much.

Until last month when I change to a new company using Microsoft Exchange
Server. I cannot send anymore Excel with attachment by CDO. I had gone
through your website just want to confirm again that CDO doesn't support
Exchange Server (and only smtp)? that means I have to use click-it at
outlook? But I got hundreds of email to send everyday.

An option is use gmail, and I did. But the sender becomes "Angus
Casey[[email protected]]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
[[email protected]]" even I send it via smtp.gmail.com?

Angus

Or use CDO
http://www.rondebruin.nl/cdo.htm

--

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


This from Excel help files.

To send e-mail from Excel To send data as an attachment, you need
Microsoft Outlook, Microsoft Outlook Express, Microsoft Exchange Client, or
another 32-bit e-mail program compatible with the Messaging Application
Programming Interface (MAPI). Make sure Mapi32.dll is in the Windows System
folder. To send Excel data as the body of a message, you need Outlook 2000 or
later.



:

I have outlook application.
How can I know what sending mail without outlook?

 

[Ron de Bruin]

Hi Angus

I not know if it is possible to change the address in the From line when you use gmail
But you can use .ReplyTo

I see if I have time to find a solution this weekend

Note inside the code:

' Note: The reply address is not working if you use this Gmail example
' It will use your Gmail address automatic. But you can add this line
' to change the reply address .ReplyTo = "(e-mail address removed)"



--

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

Hi Ron, i want to edit my reply a little bit for not to confuse you.
I use

with iMsg
.Form = """Ron""<[email protected]>"

but when the excel is sent via smtp.gmail.com, the sender will be "Ron
<[email protected]>". I want to make it appear like "Ron
<[email protected]>" but not my gmail address?

Angus

Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" <[email protected]>"

--

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

Hi Ron,

I have been using your codes for years, they are fabulous. Thank you very
much.

Until last month when I change to a new company using Microsoft Exchange
Server. I cannot send anymore Excel with attachment by CDO. I had gone
through your website just want to confirm again that CDO doesn't support
Exchange Server (and only smtp)? that means I have to use click-it at
outlook? But I got hundreds of email to send everyday.

An option is use gmail, and I did. But the sender becomes "Angus
Casey[[email protected]]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
[[email protected]]" even I send it via smtp.gmail.com?

Angus

:

Or use CDO
http://www.rondebruin.nl/cdo.htm

--

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


This from Excel help files.

To send e-mail from Excel To send data as an attachment, you need
Microsoft Outlook, Microsoft Outlook Express, Microsoft Exchange Client, or
another 32-bit e-mail program compatible with the Messaging Application
Programming Interface (MAPI). Make sure Mapi32.dll is in the Windows System
folder. To send Excel data as the body of a message, you need Outlook 2000 or
later.



:

I have outlook application.
How can I know what sending mail without outlook?

 

[Angus]

Hi Ron,

Thanks for the quick reply.

I tried but it didn't work. The sender is still (e-mail address removed),
however, there is no error message when passing thought this line .ReplyTo =
"(e-mail address removed)" and cannot see how it changes the email.

Angus

Hi Angus

I not know if it is possible to change the address in the From line when you use gmail
But you can use .ReplyTo

I see if I have time to find a solution this weekend

Note inside the code:

' Note: The reply address is not working if you use this Gmail example
' It will use your Gmail address automatic. But you can add this line
' to change the reply address .ReplyTo = "(e-mail address removed)"



--

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

Hi Ron, i want to edit my reply a little bit for not to confuse you.
I use

with iMsg
.Form = """Ron""<[email protected]>"

but when the excel is sent via smtp.gmail.com, the sender will be "Ron
<[email protected]>". I want to make it appear like "Ron
<[email protected]>" but not my gmail address?

Angus

Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" <[email protected]>"

--

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


Hi Ron,

I have been using your codes for years, they are fabulous. Thank you very
much.

Until last month when I change to a new company using Microsoft Exchange
Server. I cannot send anymore Excel with attachment by CDO. I had gone
through your website just want to confirm again that CDO doesn't support
Exchange Server (and only smtp)? that means I have to use click-it at
outlook? But I got hundreds of email to send everyday.

An option is use gmail, and I did. But the sender becomes "Angus
Casey[[email protected]]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
[[email protected]]" even I send it via smtp.gmail.com?

Angus

:

Or use CDO
http://www.rondebruin.nl/cdo.htm

--

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


This from Excel help files.

To send e-mail from Excel To send data as an attachment, you need
Microsoft Outlook, Microsoft Outlook Express, Microsoft Exchange Client, or
another 32-bit e-mail program compatible with the Messaging Application
Programming Interface (MAPI). Make sure Mapi32.dll is in the Windows System
folder. To send Excel data as the body of a message, you need Outlook 2000 or
later.



:

I have outlook application.
How can I know what sending mail without outlook?