Output one PDF for each client to email

[uoghk]

I have a table of sales transactions for all clients.


I want to loop through this table, to email each client a PDF file.
I use below command to generate PDF.

Docmd.OutputTo acReport, "ClientTransactionsReport", acFormatPDF, "C:\Temp\ClientTran.pdf"

But it generate all clients' transaction into 1 PDF.
How to output 1 PDF for each client?
Thanks.

[June7]

Common topic. Code steps:

1. open a recordset of clients

2. loop through recordset to open report filtered by ClientID in record

3. DoCmd.SendObject

4. close report

5. move to next record

6 repeat

https://www.accessforums.net/showthr...ultiple+emails

[Gicu]

Some additional info:
https://www.accessforums.net/showthr...363#post485363
https://www.access-programmers.co.uk.../#post-1783715
Cheers,

[Welshgasman]

Even look at the Similar Threads links at the bottom of this thread.?