help with Outlook macro


C

CAN

Hello everyone, I am new to the group and just baby stepping my way
into Outlook macros. I need a simple solution.

I run 2003 Outlook and I need to creat a simple macro that will write
a reply to a message. I intend to use this macro to reply to certain
customers under certain conditions by clicking a icon assigned to the
macro.


This is a sample of something I like to say when I click on the macro
icon:


"Thank you for contacting this office, you request has been
processed
as per your instructions. Please update your records accordinly and
fee free to contact us again for any questions"


Once I learn the correct programming code, I intend to write other
similar replies


Thank you very much for all the help


Thank you
 
Ad

Advertisements

M

Michael Bednarek

Hello everyone, I am new to the group and just baby stepping my way
into Outlook macros. I need a simple solution.

I run 2003 Outlook and I need to creat a simple macro that will write
a reply to a message. I intend to use this macro to reply to certain
customers under certain conditions by clicking a icon assigned to the
macro.


This is a sample of something I like to say when I click on the macro
icon:


"Thank you for contacting this office, you request has been
processed
as per your instructions. Please update your records accordinly and
fee free to contact us again for any questions"


Once I learn the correct programming code, I intend to write other
similar replies
This should get you started:

Sub ReplyType1()

Dim myReply As MailItem
Const myMessage As String = "Thank you for contacting this office, your request has been processed as per your instructions." _
& vbCr & "Please update your records accordingly and feel free to contact us again for any questions."

Set myReply = Application.ActiveInspector.CurrentItem.Reply
myReply.Body = myMessage
myReply.Display ' or myReply.Send

End Sub

Good luck.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top