We help IT Professionals succeed at work.

How to Create a Form in Outlook 2007 for recipients to complete and send to me via email

amriska
amriska used Ask the Experts™
on
I am going to send mass emails through Microsoft Word 2007 Email Merge Option.  I want in the body of the email for email recipients to be able to send me certain required information.  They would do that when see they see a link in the body of the email and when clicking on a link, I want a form to come up on their screen.  In the form they would fill the following information:

Owner Email Address:

Administrative Contact Name:
Administrative Contact Email Address :

Emergency Contact Name:
Emergency Contact Email Address:

And they have the option to check "No changes are necessary"

When they click on "Send" button on the form, an email would be sent to me and the email body would include information they filled in the form.

Is it possible to have a Macro that would perform the above request.

I have Microsoft Outlook 2007.

Thank You

Amreska
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chris BottomleySoftware Quality Lead Engineer
Top Expert 2011

Commented:
>>> when clicking on a link, I want a form to come up on their screen

There is nothing you can do that I know of that will meet this requirement.  How the recipients mail client treats an incoming mail is user specific and I would not want an email client that allowed a sender to run code on my machine!

Chris

Author

Commented:
Chris,

How about a form embedded in the body of the email.  So that they see the form in front of them, then they fill it out and click send, which will also be in the body of the email.

Would that work?

Thanks,
Amreska
Chris BottomleySoftware Quality Lead Engineer
Top Expert 2011

Commented:
You can for example fill the HTML body with a table and request they reply .. but again if their client does not include the received mail text then the table would not be received.

If however you want to proceed in the hope they include they original in their reply then we can have a go.

Chris

Author

Commented:
Chris,

Ok try.

Thanks
Chris BottomleySoftware Quality Lead Engineer
Top Expert 2011

Commented:
Can you give a representative example of how the table should look because it will have to be generated and it's not something I would want to do too many times

Chris

Author

Commented:
Hi Chris,

I just want it one column, listed as above:

Owner Email Address:

Administrative Contact Name:
Administrative Contact Email Address :

Emergency Contact Name:
Emergency Contact Email Address:

I also would like for them to have the option to check "No Changes are necessary"

Then they would click on a link to send me the above information only
Chris BottomleySoftware Quality Lead Engineer
Top Expert 2011

Commented:
APologies been distracted.  I'll try and have a go at generating a table as part of an HTML mail body in the morning

Chris
Software Quality Lead Engineer
Top Expert 2011
Commented:
The following is an examplke of some code to generate a table in your email.  I am not happy with the checkbox as it is fiddly to select ... but have had no luck finding any improvement therefore:

Sub html1()
Dim olkApp As Object
Dim olMailItem As Object

    Set olkApp = CreateObject("Outlook.Application")
    Set olMailItem = olkApp.CreateItem(0)
    With olMailItem
        .BodyFormat = 2
        .To = "xyz@abc.com"
        .Subject = "TBD - Subject"
        .HTMLBody = ""
        .HTMLBody = .HTMLBody & "<INPUT TYPE=""checkbox"" NAME=""NCR"">No Changes Required"
        .HTMLBody = .HTMLBody & "<BR>"
        .HTMLBody = .HTMLBody & "<BR>"
        .HTMLBody = .HTMLBody & "<table BORDER=1 WIDTH=60%>"
        .HTMLBody = .HTMLBody & "<tr>"
        .HTMLBody = .HTMLBody & "<td WIDTH=40%>"
        .HTMLBody = .HTMLBody & "Owner eMail:"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "<td WIDTH=60%>"
        .HTMLBody = .HTMLBody & "&nbsp;"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "</tr>"
        
        .HTMLBody = .HTMLBody & "<tr>"
        .HTMLBody = .HTMLBody & "<td>"
        .HTMLBody = .HTMLBody & "Admin Contact Name:"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "<td>"
        .HTMLBody = .HTMLBody & "&nbsp;"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "</tr>"
        
        .HTMLBody = .HTMLBody & "<tr>"
        .HTMLBody = .HTMLBody & "<td>"
        .HTMLBody = .HTMLBody & "Admin Contact eMail:"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "<td>"
        .HTMLBody = .HTMLBody & "&nbsp;"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "</tr>"
        
        .HTMLBody = .HTMLBody & "<tr>"
        .HTMLBody = .HTMLBody & "<td>"
        .HTMLBody = .HTMLBody & "Emergency Contact Name:"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "<td>"
        .HTMLBody = .HTMLBody & "&nbsp;"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "</tr>"
        
        .HTMLBody = .HTMLBody & "<tr>"
        .HTMLBody = .HTMLBody & "<td>"
        .HTMLBody = .HTMLBody & "Emergency Contact eMail:"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "<td>"
        .HTMLBody = .HTMLBody & "&nbsp;"
        .HTMLBody = .HTMLBody & "</td>"
        .HTMLBody = .HTMLBody & "</tr>"
        .HTMLBody = .HTMLBody & "</table>"
        .Display
    End With

End Sub

Open in new window


Chris
Most Valuable Expert 2012
Top Expert 2012

Commented:
Chris - can you not create a template using Outlook and use that?  Or at least use that to generate the HTML needed?

Dave

Author

Commented:
Hi Chris, can you help me on this question:

http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_27838265.html

Thanks,

Amreska