Report to mail

[weeze2]

Hi there
I have a report that consists of data shown by department. I need to generate a mail for each department, so that each department gets the data for themselves, send to them.
I am quite new to this topic and I am not sure of the possabilities of generating mails automatically from a report.
Is it possible with some code to send mails when a report is generated (Mailprogram is Lotus Notes)?

 

[KenReay]

Hi

Yes it is quite possible to do this.

Since you need to send a report to each dept, presumably with only their section, then you need some vba to loop through the list of departments (eg department table) and and have your report based on a query which has a criteria of the 'current' department in your loop Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[weeze2]

Is there anybody that have tried this before and have an example of such code. I have tried looking around but being new at this it is hard to know wheer to start.
Any help appreciated

 

[weeze2]

Stupid me..
I found out that when adding a button to a form, Access can do the work for one..It just made my day