Send report individually by email address (DoCmd.SendObject)

[nndatabase]

Can you help me please?
I need to send the report using DoCmd.SendObject. However, I need to send it based on each tech's job via email.
Currently all tech and jobs on the reports together. I need it to pull the email address and only send to that tech its jobs.
Currently I'm using the basic vba code

DoCmd.SendObject acSendReport, "R_DispatchInspectors", acFormatPDF, "email@me.com", , , "Job number", "Please see attached", False

However do I allows this to send individual report connected to email address. (Which will have each tech's specific jobs sent to them only).
FYI:
table name: Inspectors (this one have their email address)


Table name: JObs
Report name: R_DispatchInspectors

[pbaldy]

See if this gets you started:

Emailing a different report to each recipient

[nndatabase]

Hi Pbaldy,
Yes this gets me started. However I'm not that skilled to read the VBA for the link.
Can you help me?

I really just need the code that allows me to pull the email address from the report in separate reports.
Sort of a
Where the Inspector's email = ID connected to the jobs. So that all job for that inspectors are included in one email.
Is there a simple (equal to/ = to ) code?

[June7]

Along with Paul's suggestion about filtering report, example for sending individual emails https://www.accessforums.net/program...ses-37200.html