Am using code found at this link to send a formatted, automated email reminder to contractors who have not responded to requests for data. That part works great. Lotus Notes is the mail client, using Access 2002/3.
We also use Adobe Professional 9.3.2, which has a very nice interface with Lotus Notes where you can create a binder file in PDF and append emails to it as they come in and relate to that Contractor. The functionality is found under the Lotus Notes 'Actions' menu item, 'Append Selected Message(s) to existing Adobe PDF'
Since we have automated the reminder emails and the request data emails, I was hoping there would also be a way to automate appending the sent email to the existing Adobe PDF file, which will have a static directory address at the point in time the email is created. For that matter, we are also automatically sending the original request via Access, along with the attachments to the contractor, and at that point in time we manually go into Notes and select the sent email and choose the Notes / Actions / 'Convert Selected Message(s) to Adobe PDF'. This creates the initial binder PDF where all subsequent emails can be appended to. It would be extremely useful to find a way to automatically create the original PDF binder file with the first email to contractor, then store the name/server location to use for all subsequent emails sent from Access.
Any links or ideas would be greatly appreciated, I am still researching and no luck yet. Hope this makes sense, and thank you very much, Cathy