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

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

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:
> 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

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

nduerr@morrisseyinc.com wrote in news:1194471805.100580.291760
@k79g2000hse.googlegroups.com:

> 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

Air code to save the files (in this case from only one record):

Public Sub AirCode()
Dim Parent As Recordset
Dim Children As Recordset2
Dim AttachmentField As Field2
Set Parent = DBEngine(0)(0).OpenRecordset( _
"SELECT * FROM Employees WHERE EmployeeID=1")
With Parent
If Not .EOF Then
Set AttachmentField = Parent.Fields("pdf")
' the attachment fields name is "pdf"
Set Children = AttachmentField.Value
With Children
While Not .EOF
..Fields("FileData").SaveToFile _
"C:\Documents and Settings\Lyle Fairfield\Desktop\" & .Fields("FileName")
..MoveNext
Wend
End With
End If
End With
Set Children = Nothing
Set Parent = Nothing
End Sub

(indents removed in hopes of fewer news reader/writer induced
linebreaks.)

Then I suppose one could just use whatever one would normally use to send
attachments.





--
lyle fairfield

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
wrote:

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



>On Nov 7, 4:43 pm, ndu...@morrisseyinc.com 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