send emails with attachments using access

[marinos]

I have found a small access file which mass mails based on a table
(created by Jerry Whittle some years ago).
In that same file, the user can select to send tables or queries of
the same db in rtf format.
Is there a way to choose an attachment from a different location (i.e.
a pdf file) and send that as an attachment to all?

Thanks

Marinos

[Rick Brandt]

marinos wrote:

I have found a small access file which mass mails based on a table
(created by Jerry Whittle some years ago).
In that same file, the user can select to send tables or queries of
the same db in rtf format.
Is there a way to choose an attachment from a different location (i.e.
a pdf file) and send that as an attachment to all?

Thanks

Marinos

The built in command for sending an Email SendObject, cannot do what you are
describing. However; if you use automation code to automate an external
messaging library like Outlook or CDO then you can do that.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com