I am trying to make a form that will evaluate a number of things for a group
of people and then send individual emails to each person about their results.
So I want to only send a portion of data from the page to each person. I
have decided to use a new worksheet for each person as an output form. This
will make it so I can send the whole worksheet, however what I am needing to
know is how to program the VB side to send the worksheet data inline in an
email. I would prefer if it did not require the use of Outlook as some of
the other users of this tool may not use Outlook. If there is some way to
make it use the default mail program that would be best. Any help you all
can be would be greatly appreciated.

Ron Thanks for replying so fast. I actually did a search on this and found
your site before but it is all about sending from Outlook. While the rest of
the code will work it would be really helpful if I couls strip the outlook
dependant coding parts. However I have to admit ignorance in outlook and
some aspects of Excel programming that you used. Do you have any suggestions
on how to make it just use a default mail client instead of specific to
Outlook?

"Ron de Bruin" wrote:

Hi Brad

Start here
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Brad Sumner" wrote in message ...
I am trying to make a form that will evaluate a number of things for a group
of people and then send individual emails to each person about their results.
So I want to only send a portion of data from the page to each person. I
have decided to use a new worksheet for each person as an output form. This
will make it so I can send the whole worksheet, however what I am needing to
know is how to program the VB side to send the worksheet data inline in an
email. I would prefer if it did not require the use of Outlook as some of
the other users of this tool may not use Outlook. If there is some way to
make it use the default mail program that would be best. Any help you all
can be would be greatly appreciated.

Hi Brad

There are Code examples for Outlook and Outlook Express on my site.

Another option on my site is (CDO not use a mail program)
http://www.rondebruin.nl/cdo.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Brad Sumner" wrote in message ...
Ron Thanks for replying so fast. I actually did a search on this and found
your site before but it is all about sending from Outlook. While the rest of
the code will work it would be really helpful if I couls strip the outlook
dependant coding parts. However I have to admit ignorance in outlook and
some aspects of Excel programming that you used. Do you have any suggestions
on how to make it just use a default mail client instead of specific to
Outlook?

"Ron de Bruin" wrote:

Hi Brad

Start here
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Brad Sumner" wrote in message ...
I am trying to make a form that will evaluate a number of things for a group
of people and then send individual emails to each person about their results.
So I want to only send a portion of data from the page to each person. I
have decided to use a new worksheet for each person as an output form. This
will make it so I can send the whole worksheet, however what I am needing to
know is how to program the VB side to send the worksheet data inline in an
email. I would prefer if it did not require the use of Outlook as some of
the other users of this tool may not use Outlook. If there is some way to
make it use the default mail program that would be best. Any help you all
can be would be greatly appreciated.