By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

VBA for sending individual reports via outlook automatically

P: 1
I have a report to send crdit notes to clients . I need to automatically create individual reports for each client showing credit note of his own.

I want a separate report printed to pdf for each different client, the field identifying the different clients is: Company

At the moment I have to open the report, using the query to individually select the Company . It is obviously too cumbersome to do this 500 times each month!

Pls Help!!
Mar 1 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
You'll need a loop in your code then, to process through each client individually. For each client produce the report filtered to that particular client.
Mar 1 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.