Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2015, 08:48 AM
mylifedesire mylifedesire is offline Outlook macro to ask trainers to enter number of users attended the training in email itself Windows 7 32bit Outlook macro to ask trainers to enter number of users attended the training in email itself Office 2013
Novice
Outlook macro to ask trainers to enter number of users attended the training in email itself
 
Join Date: Apr 2015
Posts: 2
mylifedesire is on a distinguished road
Default Outlook macro to ask trainers to enter number of users attended the training in email itself

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?
Reply With Quote
  #2  
Old 04-03-2015, 11:07 PM
gmayor's Avatar
gmayor gmayor is offline Outlook macro to ask trainers to enter number of users attended the training in email itself Windows 7 64bit Outlook macro to ask trainers to enter number of users attended the training in email itself Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 3,557
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook macro to ask trainers to enter number of users attended the training in email itself enter a constant based on entered number So New2 This Word VBA 1 10-17-2014 05:29 AM
Outlook macro to ask trainers to enter number of users attended the training in email itself Enter a number in a locked equation within a cell that then calculates Carchee Excel 7 06-13-2014 11:11 AM
Outlook macro to ask trainers to enter number of users attended the training in email itself VBA code to read number of footnote and enter in text rekent Word VBA 2 05-13-2014 06:53 AM
email being redirected to a user not on list of users to be sent to sjvjoe Outlook 0 09-26-2012 12:42 PM
Outlook macro to ask trainers to enter number of users attended the training in email itself Enter Number on any sheet one time only. paulrm906 Excel 1 04-28-2006 07:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft