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

Cathy,

Greetings. Just out of curiosity, which version of Lotus Notes are you using?


AvgJoe

Thank you, version is 8.5.

Cathy,

Thanx for the reply. The majority of us are on 8.5.1 (some of us are on 8.5.2), but we're using a modified Lotus Notes template. That might explain why I'm not seeing what you're describing.


AvgJoe

Cathy,

I'm not sure, but this might help - MkDir link.

Additionally, I saw that you could do the same (append) for folders as well as individual messages. Is having individual folders for Contractors practical (for you) in this instance?


AvgJoe

I apologize for not being clear, I see I missed important information. We are 8.5.1, but the added items on the Actions menu only showed up in Notes after Adobe Professional 9.3.2 was installed, at least it didn't show up in our menu till then for us. We had to allow updates on Adobe - I'm not sure which update version (our Adobe started at 9.0) made the menu show up in Notes, but somehow there is a connection and one day we noticed the additional menu items and it is such a powerful capability, if the functionality could be somehow incorporated into the code added to Access for the auto-emails, it would be a real time-saver.

Hope this helps, and thank you very much for the link, that will come in handy to automate the folder making side on the server, as we do create individual folders for each contractor, and further update with subfolders for each year, so that is a very nice link, thank you, Cathy

If it will help, I found this link on the Adobe site, describing the PDF functionality with email, apparently it is PDFMaker that is involved. Am still researching, and appreciate any info that may help, thank you again, Cathy