Need help with auto reply based on text in body

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, I have looked through the rules in outlook 2000, 2003 and 2007 and can
not find anything that lets me "auto send" mail based off of an email that
will be in the body of the email recieved.
Ebay sends us an email stating that (e-mail address removed) has won the auction
and to contact him with payment info, but the reply to address is the
@ebay.com address. I could have swore there was a way to do this in VBscript
but cant seem to figure it out.
The reason we cant set ebay up to send the info out is because we are
handling ebay sales for an etailer for a commission, and they still want all
payments processed through their secure payment page.
Please feel free to contact me if you think you can help, I am at a brick
wall :( my vb skills are lacking these days (if you don't use it you
eventually DO lose it)
adam_rogers at hotmail will be the fastest way to get ahold of me. thanks in
advance for any help you can provide!
 
Sounds like a "run a script" rule action could help. This actually uses not an external script but a VBA procedure with a MailItem or MeetingItem as its parameter. That item is processed by the code:


Sub RunAScriptRuleRoutine(MyMail As MailItem)
Dim strID As String
Dim olNS As Outlook.NameSpace
Dim msg As Outlook.MailItem
Dim rep as Outlook.MailItem

strID = MyMail.EntryID
Set olNS = Application.GetNamespace("MAPI")
Set msg = olNS.GetItemFromID(strID)
Set rep = msg.Reply
rep.Body = "Your text goes here"
rep.Send

Set rep = Nothing
Set msg = Nothing
Set olNS = Nothing
End Sub

If you need to parse out an email address from the message body, regular expressions can be helpful for that. See http://www.outlookcode.com/d/vbscript.htm for links to references.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Thank you so much Sue, my fiancee has been on me to try to figure this one
out for a while now and this looks like it will work for me. you are the best!
 
Back
Top