Need help and let me know if this macro is already available to re-use.



I am looking for a Outlook email macro for following two scenarios:

Why I need the these macros:
I support client from remotely and lot of communication and interact on project virtually through MS Outlook and other tools. I want to send a simple form where i want client to just click or enter in 1 or 2 key enters so that they will have easy response method and do not feel that they have to go through long process of clicking email link and then enter their responses. For administration, I should get the response in a email that should be exported into EXCEL.

1) Scenario 1:
There are say 1000 people to train on an app and there are about 50 trainers spread across the globe and I want them to tell me just the count how many people they have trained at their location. Well this could be captured through the email and we may not receive responses from all 50 trainers. hence I want to send them one email and they should enter the count value in the outlook email template itself and i can export this value for all the 50 trainers in excel to get all my statistics in one go. Just imagine if there are 50 emails when all the 50 trainers have responded then its very cumbersome for me to do 50 iterations and see the count and update my sheet

2) Scenario 2:
In the similar case as above, I want a form in Outlook email itself where people will respond to survey questions rather then clicking on Survey monkey tool etc.

Is this possible?

The simplest way to do this, and it doesn't need macros, is to create the message in Outlook. I would recommend using a simple two column table with the questions on one side and the answers on the other. Save it as a template, then create new messages from that template.

As all the replies will have the same format, it is relatively simple to collate the returns into Excel - see http://www.gmayor.com/extract_data_from_email.htm,

or

http://www.gmayor.com/extract_email_data_addin.htm

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com