Pausing execution before SendObject method

[Creosote65]

Hi,

I have two commands that go as follows:

DoCmd.OpenReport "rptSingleQuoteforEmailEng", acViewPreview, , "ReqNo=" & [txtReqNo]

DoCmd.SendObject acSendNoObject, , , strSentTo, , , "Request no. CAT" & [txtReqNo] & " for approval.", _
"Please approve request no. CAT" & [txtReqNo] & " for customer no. " & [cmbCustNo] & ", " & [txtCustName] & "."

What I'm trying to do is have the user print the report to a pdf file (as a selected printer (Acrobat Distiller)) on their desktop, then attach the pdf output to the new email and send it off.

My problem is that Outlook grabs the focus from Access, like a modal. How do I permit the user to save the file before the email comes up?

Thanks,

Creo!

 

[PJStephenson]

I think you need to try doing this in a different way.
Have a look at this faq for saving to .pdf: faq705-1635 ,then try sending the created file with sendobject.
hope this helps
Peter

 

[Creosote65]

Thanks Peter,

I found my solution with faq703-2533. All is well.

Creo!