+ Reply to Thread
Results 1 to 4 of 4

Sending Mail from Excel

  1. #1
    Brad Sumner
    Guest

    Sending Mail from Excel

    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.

  2. #2
    Ron de Bruin
    Guest

    Re: Sending Mail from Excel

    Hi Brad

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

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


    "Brad Sumner" <[email protected]> wrote in message news:[email protected]...
    >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.




  3. #3
    Brad Sumner
    Guest

    Re: Sending Mail from Excel

    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" <[email protected]> wrote in message news:[email protected]...
    > >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.

    >
    >
    >


  4. #4
    Ron de Bruin
    Guest

    Re: Sending Mail from Excel

    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" <[email protected]> wrote in message news:[email protected]...
    > 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" <[email protected]> wrote in message news:[email protected]...
    >> >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.

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1