| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
send mail without outlook
I have outlook application.
How can I know what sending mail without outlook? *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To send a e-mail via Outlook which triggered by excel | Excel Programming | |||
| Macro to send a mail to outlook | Excel Discussion (Misc queries) | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| Help for Send Mail via Outlook | Excel Programming | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
Linear Mode
