emailing pictures in reports

[Dave]

I have a report that has a picture in it along with some information about
the picture.
the report prints out no problems

i now need ot be able to email the report

i use the sendobject function and send the report as an attachment in html
format.

all of the text boxes and lables email ok BUT the picture box is not there,
is it not possible to include pictures when emailing html?

thanks for any help suggestions

cheers
Dave

 

[Dave]

Sorry, forgot to mention i am using A97

 

[Arvin Meyer]

Either, use the snapshot format. It's in the SP-1 service pack for Access
97. or use an Acrobat (pdf) format to email your reports. That way you will
preserve the graphics.

The snapshot format includes a viewer you can send with your report the
first time (for those who don't have Access) There are several free pdf
creators available too. Just google for: CutePDF or PDFCreator
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Dave]

great, thanks for that

I downloaded and installed the SR-1 pack for office and now i can use the
snap shot but 1 question

how do i specify to use the snap shot

i used something like this

docmd.SendObject acSendReport,"rpt_test",acformatSNAP ,"(e-mail address removed)" ,
"Hope this works","please see attachment",False

i have tried acFormatSNAP, acFormatSNAPSHOT and acFormatSS but it still
prompts me for the format.

Although this would do the job i really would like to automate the whole
process

I have looked in the help file but it doesnt seem to have been updated along
with access and i have looked in the constants and cant find one that looks
like it would do the job, i only see ASP, HTML, IIS, RTF, TXT and XLS

so what should i put for the outout format?

thanks again

Dave

 

[Dave]

I found the solution

"SnapshotFormat(*.snp)"

in the output format

thanks for your help

dave