bigal.nz
03-18-2016, 12:00 PM
Hi All,
A quick overview of what I want to try to do:
I have a table and want to email out a report with the option for the people the report is emailed to, to provide feedback via a comments field (for each item in result set).
My environment is Office 2007.
Although there seems to be a external data input via email I could not get this to work.
I am wondering if there is a way to do this with VBA by scripting a HTML email to go out, that would have a series of input boxes based on the report attached, ie:
RECORD ID: 1
COMMENTS: {recipient of email inserts text here on reply}
RECORD ID: 2
COMMENTS: {recipient of email inserts text here on reply}
When the email is received back it could be cut n paste into the table or perhaps outlook can script the update in VBA.
Or is there a better way?
Cheers
-Al
A quick overview of what I want to try to do:
I have a table and want to email out a report with the option for the people the report is emailed to, to provide feedback via a comments field (for each item in result set).
My environment is Office 2007.
Although there seems to be a external data input via email I could not get this to work.
I am wondering if there is a way to do this with VBA by scripting a HTML email to go out, that would have a series of input boxes based on the report attached, ie:
RECORD ID: 1
COMMENTS: {recipient of email inserts text here on reply}
RECORD ID: 2
COMMENTS: {recipient of email inserts text here on reply}
When the email is received back it could be cut n paste into the table or perhaps outlook can script the update in VBA.
Or is there a better way?
Cheers
-Al