Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing reports
I have created a program that will update a master spreadsheet every month.
At the end of this process, I have 13 files that will need to be emailed to different people. I currently use Eudora as my email client and I'm wondering if I can write a macro that will interface with Eudora to send these files to a distrubtion list using one of the stationaries that I have created? If not, then I do have the ability to use Outlook 2007 to at least send the messages out. I need to know what I need to do to be able to get Excel macro to interface with Outlook to send the message to a distrubtion list. thanks for the help in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing reports
Hi Harddrive747
See this example for Outlook http://www.rondebruin.nl/mail/folder2/files.htm See also the other examples on this page http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Harddrive747" wrote in message ... I have created a program that will update a master spreadsheet every month. At the end of this process, I have 13 files that will need to be emailed to different people. I currently use Eudora as my email client and I'm wondering if I can write a macro that will interface with Eudora to send these files to a distrubtion list using one of the stationaries that I have created? If not, then I do have the ability to use Outlook 2007 to at least send the messages out. I need to know what I need to do to be able to get Excel macro to interface with Outlook to send the message to a distrubtion list. thanks for the help in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing reports
Ron, thank you for this, I have been able to get it to work. Now the next
thing that I would like to do is two fold. 1. I would like to "format" the data in the body of the message. I tried putting in the HTML code, but the system didn't see it that way. 2. I would like to be able to put multiple lines in the body, so that I read it in visual basic the way that I would read and email. I don't want it all on one line. Thanks again, this will save me a lot of time. "Ron de Bruin" wrote: Hi Harddrive747 See this example for Outlook http://www.rondebruin.nl/mail/folder2/files.htm See also the other examples on this page http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Harddrive747" wrote in message ... I have created a program that will update a master spreadsheet every month. At the end of this process, I have 13 files that will need to be emailed to different people. I currently use Eudora as my email client and I'm wondering if I can write a macro that will interface with Eudora to send these files to a distrubtion list using one of the stationaries that I have created? If not, then I do have the ability to use Outlook 2007 to at least send the messages out. I need to know what I need to do to be able to get Excel macro to interface with Outlook to send the message to a distrubtion list. thanks for the help in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing reports
Hi
From my tips page Formatted text (HTML) If you want to create emails that are formatted you can use HTMLBody (Office 2000 and up) instead of Body. You can find a lot of WebPages on the internet with HTML tags examples. strbody = "<H3<BDear Customer</B</H3" & _ "Please visit this website to download the new version.<br" & _ "Let me know if you have problems.<br" & _ "<A HREF=""http://www.rondebruin.nl/""Ron's Excel Page</A" & _ "<br<br<BThank you</B" Use .HTMLBody = strbody then instead of .Body = strbody -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Harddrive747" wrote in message ... Ron, thank you for this, I have been able to get it to work. Now the next thing that I would like to do is two fold. 1. I would like to "format" the data in the body of the message. I tried putting in the HTML code, but the system didn't see it that way. 2. I would like to be able to put multiple lines in the body, so that I read it in visual basic the way that I would read and email. I don't want it all on one line. Thanks again, this will save me a lot of time. "Ron de Bruin" wrote: Hi Harddrive747 See this example for Outlook http://www.rondebruin.nl/mail/folder2/files.htm See also the other examples on this page http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Harddrive747" wrote in message ... I have created a program that will update a master spreadsheet every month. At the end of this process, I have 13 files that will need to be emailed to different people. I currently use Eudora as my email client and I'm wondering if I can write a macro that will interface with Eudora to send these files to a distrubtion list using one of the stationaries that I have created? If not, then I do have the ability to use Outlook 2007 to at least send the messages out. I need to know what I need to do to be able to get Excel macro to interface with Outlook to send the message to a distrubtion list. thanks for the help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report | Setting up and Configuration of Excel | |||
Generate Reports from Excel Using Seagate Crystal Reports PLs... H | Excel Programming | |||
Emailing Help | Excel Programming | |||
Emailing | Excel Discussion (Misc queries) | |||
emailing | Excel Programming |