Emailing a group of pdf files stored in 2007 Access DB as Attachment data type

[nduerr]

I have a table with pdf files stored in an attachment data type field
in a 2007 Access File. I would like to run a query that would select
a group out of this table (easy part) then send the pdf file stored in
the attachment field in each of the selected records to a specific e-
mail address as an attachment to the e-mail. The pdf files can be
zipped together or left separately.
First off, Is this possible? I haven't found a lot of info on how to
use this field type.
If it is possible can you outline the process for me.

Thanks for the help!
Nick

[FMS Development Team]

On Nov 7, 4:43 pm, [e-mail] wrote:

I have a table with pdf files stored in an attachment data type field
in a 2007 Access File. I would like to run a query that would select
a group out of this table (easy part) then send the pdf file stored in
the attachment field in each of the selected records to a specific e-
mail address as an attachment to the e-mail. The pdf files can be
zipped together or left separately.
First off, Is this possible? I haven't found a lot of info on how to
use this field type.
If it is possible can you outline the process for me.

Thanks for the help!
Nick

Out Total Access Emailer product supports this, plus a lot of other
features to let you send personalized emails and filtered reports
(including PDF files in Access 2007) to your contacts.

For more information including a fully functional demo, visit
http://www.fmsinc.com/Products/Emailer/index.asp

Luke Chung
President
FMS, Inc.
http://www.fmsinc.com

[Tom van Stiphout]

On Thu, 08 Nov 2007 05:01:52 -0000, FMS Development Team
<fm****@gmail.comwrote:

You hit the Send button before inserting a code snippet.
-Tom.

>On Nov 7, 4:43 pm, [e-mail] wrote:

>I have a table with pdf files stored in an attachment data type field
in a 2007 Access File. I would like to run a query that would select
a group out of this table (easy part) then send the pdf file stored in
the attachment field in each of the selected records to a specific e-
mail address as an attachment to the e-mail. The pdf files can be
zipped together or left separately.
First off, Is this possible? I haven't found a lot of info on how to
use this field type.
If it is possible can you outline the process for me.

Thanks for the help!
Nick

Out Total Access Emailer product supports this, plus a lot of other
features to let you send personalized emails and filtered reports
(including PDF files in Access 2007) to your contacts.

For more information including a fully functional demo, visit
http://www.fmsinc.com/Products/Emailer/index.asp

Luke Chung
President
FMS, Inc.
http://www.fmsinc.com