send two attachments using sendObject

J

judith

I am trying to email two reports as snapshot viewer attachments using the
sendObject command but dont know how i would attach both items

DoCmd.SendObject acReport, "chainChasePrint", "SnapshotFormat(*.snp)",
"", "", "", "Weekly Sales Office Report", "Please find attached the chain
chasing report", True, ""

As well as the report "chainChasePrint" I also want to include the report
"chainChaseAppendixReport"
I dont want two emails just two attachements

Any suggestions please
Thanks
 
J

judith

Oh .. looks like I will have to try and get my two reports into one single
one.
I have a column report with both the labels and text boxes all lined up in
the detail section on the left hand side. An On Format event checks to see if
me.left is less than the first column width and then either turns on the
visability of the labels or turns on the text boxes. This works fine for a
single page but if I try to add another field which I had hoped would just go
onto the next page it just goes into a loop. Do I need anything extra here?

Thanks for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top