E
Eldon
With the help of this list, I have been able to piece together some VBA code
to automatically send reports from Access as attachments. However, while the
loop that already has the outgoing address (in MailList) is running, the
report is being generated for that addressee, and the query that drives the
report comes up to ask the person to run the report against. It seems I
should be able to feed the person's name to generate his/her individual
report somehow from the 'MaiList' entry, without the user having to type in
the name of the addressee for each report to be generated.
I can provide the VBA code, if needed, but if anyone has a suggestion
from the above description, it would be much appreciated. TIA, Eldon
to automatically send reports from Access as attachments. However, while the
loop that already has the outgoing address (in MailList) is running, the
report is being generated for that addressee, and the query that drives the
report comes up to ask the person to run the report against. It seems I
should be able to feed the person's name to generate his/her individual
report somehow from the 'MaiList' entry, without the user having to type in
the name of the addressee for each report to be generated.
I can provide the VBA code, if needed, but if anyone has a suggestion
from the above description, it would be much appreciated. TIA, Eldon