![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
|
||||
|
||||
|
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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
enter a constant based on entered number
|
So New2 This | Word VBA | 1 | 10-17-2014 05:29 AM |
Enter a number in a locked equation within a cell that then calculates
|
Carchee | Excel | 7 | 06-13-2014 11:11 AM |
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 |
Enter Number on any sheet one time only.
|
paulrm906 | Excel | 1 | 04-28-2006 07:35 AM |