Email one record per email address

[Marcie]

I have 2 tables (Employees) and a (EmployeeInformation). I want to send each
employee an email with the data they have in both tables. I would like to
automate sending this information so each employee would get their
information (and only their) when code was run.

Each person would get individual information only.

 

[Alex Dybenko]

Hi,
just prepare a report with data you want to send, then open recordset with
email addresses, and use docmd.sendobject to send this report in a loop

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Marcie]

When I do this it is emailing entire report to each person. I want each
person to only get the fields that go with their email address.

 

[Alex Dybenko]

Hi,
then you heed to filter report before sending it. This you can do by setting
underlying query sql before running report

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com