Hi All,
So I've managed to develop a nice form in the Front End of my database which is used by multiple parties to track issues and actions taken pertaining to those issues. I've managed to use VBA to generate an email that collects information from the form alerting a user that there is something there requiring their attention. However, some people do not have access to the network drive where the back end database is stored and for the moment Sharepoint is not an option.
I would really like to know if I could write some VBA code that will help me create an HTML document and manage replies as a way to allow remote staff members to update their information pertaining to an issue. I've got a fair amount of sneaky VBA code built in to this form that selects who gets the various emails my form generates (combo boxes and such) depending on types of issues and people involved. I'm hoping I can continue to use this selectivity so whatever solution I'm looking for would be based off the information present in the form being worked with rather than any underlying table.
Thanks for all the help and please let me know if I am unclear on any point.
Cheers