Guss Ginsburg
guss at beechnutconsulting.com
Wed Oct 19 10:25:20 CDT 2011
I am trying to implement a button on a form (for a call center application) so that when a case# is opened, you can click on the button and have it generate an HTML email form to the person being assigned the case, who may reply to the message with updates to specific fields on the form. When the user replies to the message it should update the specific record(s) upon hitting the designated folder in Outlook. I have been able to get this process to work once in a while when I use the External Data -> Data Collection feature on the ribbon. Lately, I have been getting messages that either the email addresses are null or invalid, or that there is no data for the records specified. Unfortunately, I did not think to capture the xml file upon one of the successful tries using the wizard. I have printed out a couple of versions of the AccessDCActionFile.xml, and perhaps I need help on what the xml file must look like in order to work as advertised. Once I get that down, I should be able to code the command button to generate xml that works. I am attaching the xml file, which I have reformatted to make it more readable. The attached file does not work. I am using Access 2010. I have set up a query based on the recordset that selects the records and fields that may be included on the html form, then walk through the wizard to generate the email form. I do not actually see the email form that was generated (unless I select the recipients from my Outlook contacts folder). I have a suspicion that the problem may be something in the xml being generated, but don't know what it should look like exactly. Any ideas? Thank you very much. Sincerely yours, Guss Ginsburg Beechnut Consulting Services 5247 Beechnut Street Houston, TX 77096 Ph: 713-667-8216 Cell: 713-553-6298 <http://www.beechnutconsulting.com> www.beechnutconsulting.com