help with outlook scripting

Status
Not open for further replies.

sblee

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Dear All

Really appreciate if someone can help on this. As i am very bad with Vba scripts.

Is there anyway to auto fill in the "X" in the Approve checkbox when i receive an email such as below and auto reply to the sender?

Example:
Sender: XXX@email.com.sg
==Email body start==

Mark "X" if you approve in the checkbox below
Approve ( ) Reject ( )

==Email body end==
 
Thanks Diane, appreciate it!

If it's not too much to ask, If i wanted to reply to the sender after replacing the body. Will the below work?

Sub SendNew (Item As Outlook.MailItem)

Dim objMsg As MailItem
Set objMsg = Application.CreateItem(olMailItem)

objMsg.Body = replace (item.body, "Accepted ( )", "Accepted (x)")
objMsg.Subject = "FW: " & Item.Subject
objMsg.Recipients.Add "XXX@email.com.sg "

objMsg.Send

End Sub
 
in a rule, yes, it should work. Change Send to Display and test it - that will open it on screen so you can see.

to test the script on a selected message, use this macro:

Code:
Sub RunScript()
Dim objApp As Outlook.Application
Dim objItem As MailItem
Set objApp = Application
Set objItem = objApp.ActiveExplorer.Selection.Item(1)

'macro name you want to run goes here
SendNew objItem

End Sub
 
Thanks for the advice Diane.

I tried the script on my email and it works!

Appreciate the help.



Sent from my SM-G960F using Tapatalk
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 3
S Outlook 2002- "Send" button has disappeared. Help please. Using Outlook 1
X Open Hyperlinks in an Outlook Email Message (Help with Diane's solution) Outlook VBA and Custom Forms 3
B Seeking help with Outlook rule Using Outlook 2
I Outlook for Mac 2019 using on desktop and laptop IMAP on both need help with folders Using Outlook 1
e_a_g_l_e_p_i Outlook 2010 Help setting up Gmail account in Outlook 2010 Using Outlook 3
F Microsoft Outlook Connector 14.0.6123.5001 - Help! Using Outlook 6
R seperate read layout to design in outlook 2016..Help!! Outlook VBA and Custom Forms 3
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
C need help setting up outlook first time Using Outlook 1
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
N Outlook Forms Help Outlook VBA and Custom Forms 2
K Help.... Office Outlook 2016 Using Outlook 1
E Outlook 2010 need help with rules Using Outlook 0
Jeff Davis Help fix my Outlook 2013? Using Outlook 28
C Newbie needs help with Outlook Macro Outlook VBA and Custom Forms 3
L Outlook 2002: HTML Emails Will Not Print: Please Help Using Outlook 0
A newb outlook macro help Outlook VBA and Custom Forms 1
joflo copy contents from outlook to excell - please help. Using Outlook 4
P Outlook 2010: Missing tab - "Format/Picture Tools" HELP! Using Outlook 3
E Outlook Contacts Help Using Outlook 1
M Outlook Backup help needed ASAP Using Outlook 2
C Please Help outlook 2013 Using Outlook 1
G Need help configuring a PRF for Outlook 2010 and 2013 Using Outlook 0
E Outlook Tasks Help Using Outlook 6
J IPAD Outlook OWA App - Help using Exchange 2007 Using Outlook 4
F Outlook 2010 - Need help with a custom field. Using Outlook 3
M HELP--Extract Data from 2003 outlook transfer to excel spreadsheet Using Outlook 1
R Need help getting BCM to work with my Outlook 2014 Using Outlook 4
K Help Needed - setting up Email in Outlook 2013 Using Outlook 3
M First post -help with managing two calendars Outlook 2010 /Exchange 2010 Using Outlook 0
R [VBA] complicated(?) outlook events - need help with code Using Outlook 15
C Outlook Profile Corrupt...Help!!!!! Using Outlook 0
M HELP! MSN to Outlook Using Outlook 1
A Outlook HELP Using Outlook 1
F Help with Outlook 2007 Macro Please! Using Outlook 4
P Need help/Gmail accounts show separately/Outlook 2013 Using Outlook 0
A Need Help with BCM2010 Sharing on outlook 2013 Scenario! BCM (Business Contact Manager) 1
S Desperate for Help with Outlook custom form Using Outlook 0
L Outlook 2013 IMAP account is deleting e-mails from my inbox - help!!! Using Outlook 3
J Outlook 2010 Forms Help Needed "A field in this form requires a value." Using Outlook 6
W I Need help with vb.net and outlook 2010 Using Outlook 2
S Help needed - syncing outlook emails with iphone 4s Using Outlook 4
S Outlook macro help Using Outlook 10
A outlook error Receiving reported error (0x80040900) please help Using Outlook 4
A URGENT Help in Outlook Meeting Using Outlook 3
D Help please my Outlook is frozen Using Outlook 3
makinmyway Help Using Windows Desktop Search to Index Outlook PST of another User Logon Using Outlook 14
E Outlook PST files disappear, only found temp file HELP: Using Outlook 1

Similar threads

Back
Top