I was thinking something more of in these terms:
A code that will loop 30 times that will send 30 individual reports converted to pdf (it can be XLS output format too) by email to 30 different recipients whose email addresses are stored in a table with numbers 1 to 30. Each report is named 1 to...
Yes I have tried, but can't find nothing similar, even though I think it is something a lot people might have been faced with.
I actually need to automote the SEND OBJECT (in PDF) with VBA loop, buy don't know now.
I need a code to be able to output several reports to several pdf files.
The source of the reports are 30 queries identified with numbers 1 to 30.
I need to email this reports so I just don't want to print the reports to pdf but output them to a file. If I have the email addresses of where each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.