Emailing Grouped reports seperately

[JudithJubilee]

Hello there,

I have a table with Company name and an email address.

This is linked to another table with details of Jobs done, work outstanding,
etc.

I have created a Grouped report based on Company name and set it so it
prints one on each page.

I would like to be able to email the individual companies their own section
but be able to type in my own email body on each one.

I'm fairly happy with macros and OK with VB - if explained!!

I would be very glad of anyone's thoughts on best to proceed..

Thank you in advance

Judith

 

[Arvin Meyer [MVP]]

You really need to open your report to each company, in order to email it.
You can do that by scrolling through a form which lists each company and
clicking on them one at a time, using either the SendObject Method or email
code similar to:

http://www.datastrat.com/Code/OutlookEmail.txt

If you want to add an individual comment, you need to do them one at a time.
You can run it all automatically using something like the PDF and Mail Class
Library:

http://www.groupacg.com/

but that would not let you write individual comments.

 

[a a r o n _ k e m p f]

SQL Server Reporting Services has this functionality built in.