Check sent email and reply if have specific words

Status
Not open for further replies.
L

laavista

We have Outlook 2003. I need to use vba to check "sent emails" and if they

have specific words, e.g., "Interview Scheduled", send a reply to different

addressees than the original sent email (same addressees each time, though).

I need to use "reply" as the addresses need the main content of the email,

but cannot receive the attachment.

I'm new to Outlook VBA. (I used Access VBA.)

Any help would be greatly appreciated.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
See the ItemAdd event in the VBA help file. In that event check the body of

the item with the Instr function, and call it's Reply or maybe Forward

function. For both there's a sample in the help file as well.

Best regards

Michael Bauer

Am Fri, 19 Jun 2009 19:37:02 -0700 schrieb laavista:


> We have Outlook 2003. I need to use vba to check "sent emails" and if


they
> have specific words, e.g., "Interview Scheduled", send a reply to


different
> addressees than the original sent email (same addressees each time,


though).
> I need to use "reply" as the addresses need the main content of the


email,
> but cannot receive the attachment.

> I'm new to Outlook VBA. (I used Access VBA.)

> Any help would be greatly appreciated.
 
L

laavista

Thank you so much for replying.

I will do that.

"Michael Bauer " wrote:



> See the ItemAdd event in the VBA help file. In that event check the body of
> the item with the Instr function, and call it's Reply or maybe Forward
> function. For both there's a sample in the help file as well.

> > Best regards
> Michael Bauer

> > >

> Am Fri, 19 Jun 2009 19:37:02 -0700 schrieb laavista:
>
> > We have Outlook 2003. I need to use vba to check "sent emails" and if

> they
> > have specific words, e.g., "Interview Scheduled", send a reply to

> different
> > addressees than the original sent email (same addressees each time,

> though).
> > I need to use "reply" as the addresses need the main content of the

> email,
> > but cannot receive the attachment.
> > I'm new to Outlook VBA. (I used Access VBA.)
> > Any help would be greatly appreciated.

>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
I Check if sent email has been replied Outlook VBA and Custom Forms 1
Z Check if email was sent Outlook VBA and Custom Forms 1
K check for sender, follow to my personal adress and delete the sent folder. Outlook VBA and Custom Forms 1
D Spell check Outlook VBA and Custom Forms 3
L Spell-check dictionary confusion Using Outlook 0
S How to export urls from email to excel and check the status of the url ? Using Outlook 5
N Private check box in table view Using Outlook 0
S Outlook to check for specific text Outlook VBA and Custom Forms 3
C Custom Outlook Form - Populate Information from Radio Button / Check Box Using Outlook 0
O Outlook 2016 This rule will only run when you check your email in Outlook.... Using Outlook 4
A Check for words in subject header before sending email Outlook VBA and Custom Forms 4
R Using "check for duplicates" for existing contacts Using Outlook 2
P Suppress dialog box on email check error? Using Outlook 5
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
K adding more rules to 'different domains check' macro Outlook VBA and Custom Forms 2
R Macro to check file name with outlook address book Outlook VBA and Custom Forms 0
Diane Poremsky Check Contacts before moving them to Hotmail Contacts folder Using Outlook 0
Diane Poremsky Check for missing attachments before sending a message Using Outlook 1
R Outlook 2010 Modify Style "Do not check spelling or grammar" not saving Outlook VBA and Custom Forms 0
J Send and Receive Button - only check default account? Using Outlook 1
A Check for attachment code not working Outlook VBA and Custom Forms 1
Diane Poremsky Check Message Size Before Sending Using Outlook 0
B Check for different domains macro to be triggered by specific domains only Outlook VBA and Custom Forms 2
V Check/convert to emailaddresses Outlook VBA and Custom Forms 11
JorgeDario how to check a MailItem has a digital signature (SMIME) with vba? Outlook VBA and Custom Forms 1
O Unable to check name. Using Outlook 3
R Outlook Custom form check if there an attachment Outlook VBA and Custom Forms 2
L Trying to check for the absence of mail. Outlook VBA and Custom Forms 1
S Check if two organisition is added then i have to give managers passward creteria to send mail Using Outlook 1
Peter H Williams check for new email automaticlly Using Outlook 12
C Unusual Signature & Spell Check Query Using Outlook 1
M Calendar navigation displays previous field records.check calendar is shared.. Using Outlook 3
A Can Rule Check Category Contact is assigned? Using Outlook 1
T Outlook 2007 forms: Check boxes and free text boxes not retaining data Using Outlook 1
L check if send message appears in SendItems forder before moving Using Outlook 0
C Create a rule to only check new content in email - disregard original content Using Outlook 3
M Outlook Rules check for new line character Using Outlook 1
G Outlook rule check for messages not received Outlook VBA and Custom Forms 2
E Outlook could not create the work file. Check the temp environment variable Using Outlook 8
B Custom real time, time format check Outlook VBA and Custom Forms 1
B BCM shuts down everytime I try to import/export or check for error BCM (Business Contact Manager) 10
D Check whether mail item is proper for sending or not Outlook VBA and Custom Forms 5
P Check for the distribution list existence Outlook VBA and Custom Forms 1
H out to check whether outlook configured or not Outlook VBA and Custom Forms 1
M Check Profile info Outlook VBA and Custom Forms 1
Z All Day Event Check Box Outlook VBA and Custom Forms 1
L Images not displaying in emails sent to self Using Outlook 2
S Outlook 2016 A Shortcut to recall and delete and sent message. Using Outlook 1
J Names in sent items suddenly show as Bob Smith (bobsmith@sample.com) Using Outlook 3
M Messages Intermittently Dont Arrive In Sent Items After Sending Successfully Using Outlook 4

Similar threads

Top