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.

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.

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.

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.