Emailing reports

[Harddrive747]

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.

 

[Ron de Bruin]

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

 

[Harddrive747]

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]

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><B>Dear 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><B>Thank you</B>"

Use .HTMLBody = strbody then instead of .Body = strbody