Based on your requirements I'd recommend using a COM addin and handling the
Application_ItemSend event. If you aren't deploying the code to anyone else
then you can use that event from VBA code. That event can be used to get all
the recipients of the message and to add attachments or to modify the email
body with whatever information you need.

As before, I'd suggest searching at www.outlookcode.com for code to get you
started. There are many examples of ItemSend handlers there in various
languages.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Dan" danthafdelin[at]gmail[dot]com wrote in message
...
Thanks for the reply. This would all need to be performed through Outlook.
The files would be generated by the database but that's pretty much the
only area that Access would play a part. I would need it be setup, so when
they hit send it would trigger everything or even if I could create a
button that would work just as well.

This would be done in Outlook 2007. The user also has business contact
manager, so I don't know if that makes anything easier.
Basic sequence of events would be this.

1. User creates an e-mail.
2. A contact is selected.
3. E-Mail is sent with corresponding file attachment or information in the
message.

If the event could even be triggered when the contact would be selected
that would work just as well.

I am familiar with VBA but as I'm sure you know VBA differs between the
Office applications. Same basic syntax but you have objects and such that
are specific to each app. Any suggestions?