Emailing a report (1 Viewer)

[cktcPeterson]

When I email a report and outlook opens, I am unable to click back and look at the report and or form I was working in.

Is there a work aroud to this?

 

[Ranman256]

outlook may be in modal mode (in control by Access) and wont release until the email is sent (or canceled)

 

[cktcPeterson]

Is there a way to change that? If so, how? I did a quick search and looks like all my forms, reports, say NO.

 

[Ranman256]

Does the email code use .SEND command? Once sent, it should release.

 

[June7]

Using Outlook automation?

With automation, finish procedure with code that sets objects to Nothing. Post your code.

 

[Ranman256]

yes, thats for outlook.

or theres also :
docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo, ,,sSubj, sMsgBody

 

[mike60smart]

Is there a way to change that? If so, how? I did a quick search and looks like all my forms, reports, say NO.

Hi
You can add this additional line so that you get a Preview of the Report.

DoCmd.OpenReport "ReportName", acViewPreview, , "[JobNr]=" & Me!JobNr (Use the PK to identify the required Record)