Send individual pdf attachment to individual recipients

[jja]

Hi,

I have created a database that generates a report with customer debts. I have a lot of customers and in a report each page is a different customer with individual debts info. What i would like to do is to create a button and distribute individual report page as pdf to individual customer by email. I'm using Lotus notes.
I have searched the forums i found something but it was not what i was looking for. Can you guys help?
Thanks in advance

 

[pr2-eugin]

I have not worked with Lotus, but the general idea, would be to

1. Get the recordset with all the customers with debt,
2. Loop through it, to open the report using the WHERE condition,
3. Then outputting them using the DoCmd.OutputTo method.
4. Finally use the code to send lotus notes.