Information for customers are updated throughout the morning, some of which are prompt and can be sent, others which may not be updated til later in the day. I had 2 ideas in mind
1. Can I make some kind of form or something that would populate itself with the active reports listed out. Where as the user can see all active reports and single out ones to view, print, or send as needed.
i.e.
-Customer Report Form-
- Customer 1's Report [Preview] [Print] [email]
- Customer 2's Report [Preview] [Print] [email]
2. Was to just wait til ALL info is updated and send out all at once, I've searched the internet and came up with this... http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm
I am not having luck implementing this, I am not certain where to put the code or what needs to be edited to make it work for my database. It points to several items so where do i start, make a new form for report management only?
There has got to be a solution other than creating a separate report for every customer, as this was my first idea.
Any help, ideas, suggestions would be appreciated.