emailing a Report

[prmitchell]

How do I go about emailing a report to a Client selected from a combo box on a form

thank you ion anticipation

 

[edtab]

I presume you are using a version of Access earlier than Access 2007 which has the
capacity to email your report directly from Access.

If so, the quickest way (without programming) is to print your report using a pdf writer
program which acts as a printer (e.g. CutePDF) then send it as an attachment
to your email.

CutePDF is a free downloadable program from the internet. There may be others like it
but this is one we use at work and it works well.

 

[prmitchell]

I'm using Access 2010 and I wish to email a report to the client I select from a combo box on a form, so the where clause would be
"[ClientID]=" & Forms![FormName]![ClientID]

but I have been told that SendObject
does not support a where clause
is my thinking is I have one query behind the report with the above where clause in it
and I have another report that produces and sends for all of the clients
which just becomes a bit of work when adding to/redesigning the report one needs to do this twice.

 

[pbaldy]

I have used this technique:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

Adding code like if the combo is Null to not apply a filter. That let's you use it either way.