Connecting Tech Pros Worldwide Help | Site Map

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

  #1  
Old November 7th, 2007, 09:45 PM
nduerr@morrisseyinc.com
Guest
 
Posts: n/a
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  
Old November 8th, 2007, 05:05 AM
FMS Development Team
Guest
 
Posts: n/a

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

  #3  
Old November 8th, 2007, 02:45 PM
Tom van Stiphout
Guest
 
Posts: n/a

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