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

#1 November 7th, 2007, 09:45 PM

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

#2 November 8th, 2007, 05:05 AM

On Nov 7, 4:43 pm, ndu...@morrisseyinc.com wrote:

Quote:

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

#3 November 8th, 2007, 02:45 PM

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

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

Quote:

>On Nov 7, 4:43 pm, ndu...@morrisseyinc.com wrote:

Quote:

>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

What is Bytes?

Popular Articles