Questions:email access reports in SNP&PFD formats, and send to FAX

[FSHOTT]

I am working on an application which is to send ACCESS reports to suppliers
(Monthly Supplier Performance Report cards). I am using the VBA code from the
references which I was directed to, from this forum. I use the Stephan Labans
code to convert the ACCESS report to a PDF format. I send a MS Outlook
message with 2 attachments (a snapshot {snp} and PDF version of the report).
Currently the code works if I close the open PDF version of the report before
the code increments to the next supplier (next recordset record). If I do not
manually close the displayed PDF file I get an error message (permission
denied) when I try to execute the Kill (“C:\SupplierReportCard.PDFâ€) and loop
to the next supplier. I am thinking I need to close the open PDF file after
sending the Email and before looping to the next supplier in the recordset. I
currently do not know how to do this. I use a DoCmd.Close acReport to close
the ACCESS version of the report but this does nothing for the PDF version.
So my question is, is my assumption correct that I need to close the report
before looping and if so how do I do this?
I also have an additional question. I need to send some of the suppliers a
FAX of the report versus an Email. Is there a way I can send a form of the MS
Outlook message {with attachment(s)} to a FAX location? Do I need to change
the documents I send to a FAX location? That is perhaps a cover sheet and
bitmap or other version of the ACCESS report? Thank You in advance for your
responses to my questions.

 

[Gina Whipp]

Frank,

Sounds to me like you would need to loop thru the files...

http://www.regina-whipp.com/index_files/LoopRecords.htm (Can be modified to
PDF and/or SNP)

....then grab them from whatever location you designated and eMail. I don't
know if you can merge the two codes as you didn't post the code you use to
send the eMail.

For faxing see... http://www.mvps.org/access/general/gen0009.htm

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm