ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   send mail without outlook (https://www.excelbanter.com/excel-programming/407945-send-mail-without-outlook.html)

x taol

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

*** Sent via Developersdex http://www.developersdex.com ***

JLGWhiz

send mail without outlook
 
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.

"x taol" wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***


JLGWhiz

send mail without outlook
 
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.



"x taol" wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***


Ron de Bruin

send mail without outlook
 
Or use CDO
http://www.rondebruin.nl/cdo.htm

--

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


"JLGWhiz" wrote in message ...
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.



"x taol" wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***


Angus

send mail without outlook
 
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
]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
]" even I send it via smtp.gmail.com?

Angus

"Ron de Bruin" wrote:

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

--

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


"JLGWhiz" wrote in message ...
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.



"x taol" wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***



Ron de Bruin

send mail without outlook
 
Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" "

--

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


"Angus" wrote in message ...
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
]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
]" even I send it via smtp.gmail.com?

Angus

"Ron de Bruin" wrote:

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

--

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


"JLGWhiz" wrote in message ...
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.



"x taol" wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***



Angus

send mail without outlook
 
Yes, I use .Form = ", but when the excel is sent
via smtp.gmail.com, the receipt will be "Ron ". Can
I make it appear "Ron "?

"Ron de Bruin" wrote:

Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" "

--

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


"Angus" wrote in message ...
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
]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
]" even I send it via smtp.gmail.com?

Angus

"Ron de Bruin" wrote:

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

--

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


"JLGWhiz" wrote in message ...
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.



"x taol" wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***




Angus

send mail without outlook
 

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

with iMsg
..Form = "

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

Angus

"Ron de Bruin" wrote:

Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" "

--

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


"Angus" wrote in message ...
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
]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
]" even I send it via smtp.gmail.com?

Angus

"Ron de Bruin" wrote:

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

--

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


"JLGWhiz" wrote in message ...
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.



"x taol" wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***




Ron de Bruin

send mail without outlook
 
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 = "



--

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


"Angus" wrote in message ...

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

with iMsg
.Form = "

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

Angus

"Ron de Bruin" wrote:

Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" "

--

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


"Angus" wrote in message ...
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
]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
]" even I send it via smtp.gmail.com?

Angus

"Ron de Bruin" wrote:

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

--

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


"JLGWhiz" wrote in message ...
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.



"x taol" wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***




Angus

send mail without outlook
 
Hi Ron,

Thanks for the quick reply.

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

Angus

"Ron de Bruin" wrote:

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



--

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


"Angus" wrote in message ...

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

with iMsg
.Form = "

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

Angus

"Ron de Bruin" wrote:

Hi Angus

I can't reproduce this

Do you use something like this

..From = """Ron"" "

--

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


"Angus" wrote in message ...
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
]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
]" even I send it via smtp.gmail.com?

Angus

"Ron de Bruin" wrote:

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

--

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


"JLGWhiz" wrote in message ...
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.



"x taol" wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***






All times are GMT +1. The time now is 09:09 PM.

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