Automate email

[Arendvan]

I am producing a number of reports each month - some of these reports are just printed and sent out snail mail however 80% of them can be sent by email. The problem is that each page of the report is for a different email user, and these email users change on a monthly basis - I want (if possible) to automate this process so that each page is sent seperatley to each specific user - bearing in mind that these users change on a monthly basis =- anyone got any ideas?

 

[Lightwave]

This will require quite a bit of programming - how much have you done...

First step I guess is produce all the reports for each user indvidually.

Next step is to send the reports out.

here's a start

http://www.access-programmers.co.uk/forums/showthread.php?t=131897&highlight=automate+reports

 

[NigelShaw]

Hi there

are the reports the same or individual? It wouldn't be that hard.

My methods are probably not programatically correct but what would possible do is-

have a Boolean field in the contact. RecEmail

have this field updated if email is required.

Have a new table linked to contacts as 1 to many
this table would receive report details name, filter data, date

create query that collects only contacts with true RecEmail and report filters for current month.

Run a vba code to loop through the query recordset and create a report based on the filter info in the recordset and send per person via Automated email. There is lots of code available for automated email itself.

I have never done this, just outlining a typical scenario whilst rocking my child to sleep in 30 degrees of heat! Phew.....



Nigel