Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Bounce e-mail notification (OL + Excel 2003)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers

    I will post this here first, and then see where we go.

    I have developed an Excel application, that uses Outlook to send e-mail notifications about assignmnets.

    How can I detect that Outlook has received a delivery failure notice, that the e-mail did not get to the person, so that I Excel can send the request to the second in line to fulfill the assignment needs?

    Its like Excel sends the message components to Outlook, then Outlook knows what to do with these, and does its thing by composing the message and sending it. But if Outlook does get a delivery failure, then Outlook needs to tell Excel to prepare and send a second message.

    Is this clearer than mud, or I need more words?

    Thanks for any help

    Wassim
    PS: My laptop keyboard is broken, and my fingers are too fat to open the laptop and exchange the keyboards, now what <img src=/S/drop.gif border=0 alt=drop width=23 height=23>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Bounce e-mail notification (OL + Excel 2003)

    Your requirement is clear, but the solution is not so clear. Excel does not wait around for a return code from Outlook, presumably because it could take forever to learn what happened. So Outlook needs to somehow automate something in Excel. In Outlook 2002 and later, a rule can run a VBA procedure in Outlook, so Outlook could run a procedure in Excel (maybe even the open workbook, using GetObject). But this does seem to be a tough thing to make work reliably...

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Bounce e-mail notification (OL + Excel 2003)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Jefferson

    I was imagining the solution, and I am working on it right now. Here how I think it is going to work:

    As you and I said, Excel will set things in motion, send the items needed for Outlook to send the message, and that is it, Excel now before it goes to sleep in the background, will tag the assignment and the e-mail that was used to fulfill this assignmnets. This way it will have a list of potential new messages to send.

    Now since Outlook has the capabilities to 'wait and see what goes on' and what I am talking about here, is the fact that one can ask Outlook to check for incoming messages at predetermined times. Using that feature, Outlook can be made to check for incoming mail every 30 minutes or so, and I think this is enough for a delivery failure to be generated and sent back to the sender.

    When messages come by, Outlook will analyze what messages came by via rules and filters. If one is a failure notice, then the rule will fire a VBA procedure that would send the message stuff to Excel. I hope that Excel will wake up and receive the components and deal with them by looking at the list it generated before going to sleep.

    What I am finding difficult is how to tie the failure message to the original message that created the bounce.

    It seems that delivery notices are not standardizes, so each ISP can do something different.

    Another approach is to send the message to all members who can fulfill the needs of the assignment and ask the members to reply to the system with a message that has a message ID, and that solves the 'marriage' between messages problem, but produces a second problem what happens when two members send messages at the same time. I guess human intervention here is needed.

    Am I off base, or does this make sense to someone who is not working on the project?

    I will let you know what goes on and how far I get with this project.

    Thanks again.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Bounce e-mail notification (OL + Excel 2003)

    It is true that nondelivery notices can be very different from one another. And it also is inconvenient that a lot of spam filters look for ID numbers in the subject line, since that might be one way to be sure you know what message got rejected...

Posting Permissions

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