reply to message using a custom template

Status
Not open for further replies.

lcastanheiro

Member
Outlook version
Outlook 2010 32 bit
Email Account
Hi I hope someone may be able to help me.

I am managing several petrochemical projects, and need to send, reply etc. several messages a day (sometimes something like 60 or more). I spend lots of time just to adhere to each project requirements in terms who needs to be on the TO: field, CC: filed etc. Additionally the body of the email changes in requirement for each project. For example for project X I must write in the beginning of every message the following:

Regarding: the subject of the message

In Reply to: if it is in reply to a message and if so write the message number

Reply Req’d : if a reply is required or not (YES/NO)

other projects have different requirements.

then the TO field needs to be addressed to a particular email address that never changes for that particular project, the same way the CC field is always the same. The subject changes but always starts with 2710-IN-XJCTC-E- followed by a numerical and sequential number plus the subject that matches what is in the first line of the message following the "Regarding".

So in order to save time I would like to have the option to upon receiving a message if I need to reply just click a button that would open a reply message with the address fields already fill in plus the partial subject field with "2710-IN-XJCTC-E-" and the first three lines of the body as indicated above, and includes the original message.


Is this possible?

Thanks
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Yes, it's possible using VBA...

Public Sub Replyproject1()

Dim oMail As Outlook.MailItem

Dim Item As Outlook.MailItem

Set Item = Application.ActiveExplorer.Selection(1)

Set oMail = Application.ActiveExplorer.Selection(1).Reply

With oMail
.Body = "Regarding: the subject of the message" & vbCrLf & vbCrLf & _

"In Reply to: " & Item.Subject & vbCrLf & vbCrLf & _

"Reply Req’d : if a reply is required or not (YES/NO)" & vbCrLf & vbCrLf & oMail.Body
.CC = "address"
.BCC = "address"
.Subject = "2710-IN-XJCTC-E- " & Item.Subject
.Display

End With

End Sub
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
G Reply using address a message was sent to Using Outlook 2
C Have server reply using a specific message rule not working Using Outlook 4
evdbogaard Reply with only last message cited Using Outlook 1
A VB to "reply all" email items stored in a folder of outlook with adding a new message Outlook VBA and Custom Forms 0
Diane Poremsky Outlook Crashes When You Reply or Create a New Message New Slipstick.com Articles 0
S Outlook Macro Reply to a message Outlook VBA and Custom Forms 1
D Automatically file message and reply to folder. Using Outlook 1
S Reply & Forward Date in original message incorrect Using Outlook 2
R Reply marks read message as unread Using Outlook 1
D Undeliverable message reply to invites Exchange Server Administration 2
M Automatically move Outlook message to the specific folder when click on reply to all Using Outlook 4
J How to Reply or Forward a message and Archive it in same step? Using Outlook 0
S Outlook 2013 - Customized auto-reply message Using Outlook 10
V Auto reply message after a specific time in a day Using Outlook 1
B Incoming message lost in reply Using Outlook 2
E Outlook 2010 crashes when creating (reply) a message from a Meeting Using Outlook 6
M Rules in error: Cannot reply to message Using Outlook 10
M Reply with picture in body of message Outlook VBA and Custom Forms 2
R Reply with custom form & selected data from message body Outlook VBA and Custom Forms 3
T Custom Appointment Form Message Body Deleted upon reply. Outlook VBA and Custom Forms 3
A Is there an ID field you can use to pair a reply to the sent email? Outlook VBA and Custom Forms 4
W Reply to email Using Outlook 4
A Edit attachment Save and Reply Outlook VBA and Custom Forms 0
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
B Adding signature to bottom of VBA reply email Outlook VBA and Custom Forms 1
C UDFs Reply vs Forward Outlook VBA and Custom Forms 2
ThinkToday Calculate reply time of outlook mail Using Outlook 1
W Replyin to the reply-to email address Outlook VBA and Custom Forms 0
D Reply with a template loose the sender's embedded image Outlook VBA and Custom Forms 0
R List folders in a combo box + select folder + move emails from inbox to that folder + reply to that email Outlook VBA and Custom Forms 1
J Outlook Reply > From > Other Email Address... > Address Not Showing in Sent Items... From Email Outlook VBA and Custom Forms 0
M Delete headers in Inline reply Outlook VBA and Custom Forms 5
E reply Using Outlook 0
Healy Consultants Macro to remove inside organization distribution list email address when reply to all recepients Outlook VBA and Custom Forms 0
B resend if no reply and send an automatic reminder Outlook VBA and Custom Forms 0
B Reply and replyall macro is not working Outlook VBA and Custom Forms 1
mctabish Setting "Reply To" based on inbox Outlook VBA and Custom Forms 2
Rupert Dragwater Deleted email address keeps showing up in reply Using Outlook 12
B When working on emails in a certain folder, when I hit reply or reply all, I would like it re always reply all and add an email address to send to Outlook VBA and Custom Forms 3
R How Do I insert images in and Auto Reply Using Outlook 3
D Disable or hide "reply" and "reply to all" and "forward" in email from access vba Outlook VBA and Custom Forms 1
M Reply Inline With a Outlook Template Outlook VBA and Custom Forms 6
broadbander Needing help with reply/reply all while keeping attachments and adding a new CC recipient. Outlook VBA and Custom Forms 5
O On click,I want to change subject line of selected mail and then reply to particular email and move Using Outlook 3
J VBA Run When Reply Outlook VBA and Custom Forms 4
D Font in Reply is much larger than normal, how to reset ...? Using Outlook 4
K add pdf to every reply or forward Outlook VBA and Custom Forms 1
K Extract email address from body and auto-reply outlook Using Outlook 1

Similar threads

Top