There have been many postings regarding this subject, but being relatively new to Access 2010 and not being familiar with Visual Basic (I came from the COBOL/Fortran era!) I have not been able to follow the approaches used.
I have a database that contains lists of members belonging to an organisation (600 approx.) and these members can join any number of interest groups (80 approx.). Every so often the organisation secretary needs to update the list of members in each group.
I have a form that has a header line that contains the group code, group name, leader name and leader email address. The rest of the form is a list of member numbers and names. My ideal would be to be able to email the list page to the leader's email address.
What I have done so far is to design a report that mirrors the form (and in native form lists all groups and all members) but by clicking on the group code on the form I filter and produce a report specific to one group. This contains the leader's email address. I then placed a button at the top of the form that on clicking invokes a macro that uses the emaildatabaseobject command. This sends just the one page as pdf document but I just cannot get the command to use the email address within the report. It has to be hardcoded or left blank and inserted before the email is sent. Is there any way whereby I can achieve the automatic use of the embed email address?
If possible, this still requires working through a list of 80 groups to send out the emails. Three clicks will go from a master list of groups onto a form specific to one group, from there to report page and finally to an email. 240 clicks in total!
Hence the desire to automate the whole process from a single mouse click. But 240 clicks are better than having to enter each email address separately or copying and pasting the addresses one at a time.
Any ideas?
Thanks in advance.
I have a database that contains lists of members belonging to an organisation (600 approx.) and these members can join any number of interest groups (80 approx.). Every so often the organisation secretary needs to update the list of members in each group.
I have a form that has a header line that contains the group code, group name, leader name and leader email address. The rest of the form is a list of member numbers and names. My ideal would be to be able to email the list page to the leader's email address.
What I have done so far is to design a report that mirrors the form (and in native form lists all groups and all members) but by clicking on the group code on the form I filter and produce a report specific to one group. This contains the leader's email address. I then placed a button at the top of the form that on clicking invokes a macro that uses the emaildatabaseobject command. This sends just the one page as pdf document but I just cannot get the command to use the email address within the report. It has to be hardcoded or left blank and inserted before the email is sent. Is there any way whereby I can achieve the automatic use of the embed email address?
If possible, this still requires working through a list of 80 groups to send out the emails. Three clicks will go from a master list of groups onto a form specific to one group, from there to report page and finally to an email. 240 clicks in total!
Hence the desire to automate the whole process from a single mouse click. But 240 clicks are better than having to enter each email address separately or copying and pasting the addresses one at a time.
Any ideas?
Thanks in advance.
