[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


MS Outlook: Auto Reply with an attached form

Posted on 2010-01-07
Medium Priority
Last Modified: 2012-05-08
Hi Experts, I'm putting together a simple ticketing system of sorts.  I have an outlook mail box in which users submit questions.  I want to be able to auto reply to each message that is received with a message that has an outlook form in the body (the form will be used to collect additional standard information).  In part of the form I will have a "Description" text box which I would like to automatically populate with the contents of the original email (i.e., Dear Mailbox - please help me with XYZ).  I also to populate a field for "Requester" which would contain the email address of the original sender (as an added bonus it would be really cool if this could look up the contact information and get the first/last name of the requester and the contact info).

I know this is a tall bill to fit, but any advise you have would be helpful.
Question by:JamesCbury
  • 2
  • 2
LVL 28

Expert Comment

ID: 26203463
Just design the form to your liking, then create a rule for this particular inbox (you need to create a profile in Outlook and log on to this mailbox). Make a rule that fires on all messages (don't fill in anything in the first wizard window, accept the warning). In the second wizard window, select "reply with a template" and select your form. Finished.

Author Comment

ID: 26217723
Thanks, this is pretty helpful, but I'm looking to grab some of the information that is in the original email and stick it in the form.  My next step is to post the form to a database (I haven't figured that one out yet so any thoughts would be appreciated).  If the info in the original email is in a form, I can easily post it to a field.

LVL 76

Accepted Solution

David Lee earned 2000 total points
ID: 26313595
Hi, JamesCbury.

This is possible with a simple bit of coding like that below.  Here's how to use it.

1.  Add the code below to Outlook.  You didn't specify the version of Outlook you're using, so I'm not including instructions for that here.  
2.  Create a new rule that fires for all messages.
3.  Set the rule's action to "run a script" and select this script as the one to run.

When an item arrives it triggers the rule.  The rule then runs the script.  The script creates a new message using your form, populates it with data from the message that triggered the rule, and sends the message.
Sub AutoResponse(Item As Outlook.MailItem)
    Dim olkForm As Outlook.MailItem
    'Change YourFormName to the name of your form.'
    Set olkForm = Session.GetDefaultFolder(olFolderDrafts).Items.Add("IPM.Note.YourFormName")
    With olkForm
        .Body = Item.Body
        'Your code for populating other fields goes here.'
    End With
    Set olkForm = Nothing
End Sub

Open in new window


Author Closing Comment

ID: 31674194
Thanks, this is exactly what I was looking for.  I'll play around with it a bit this week and may have some follow-up questions.

Thanks again.
LVL 76

Expert Comment

by:David Lee
ID: 26335475
You're welcome.  Glad I could help.

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses
Course of the Month19 days, 16 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question