Connecting Tech Pros Worldwide Help | Site Map

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

nduerr@morrisseyinc.com
Guest
 
Posts: n/a
#1: Nov 7 '07
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
Guest
 
Posts: n/a
#2: Nov 8 '07

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


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

Tom van Stiphout
Guest
 
Posts: n/a
#3: Nov 8 '07

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


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
Closed Thread