Christopher770
Registered User.
- Local time
- Today, 13:14
- Joined
- Sep 2, 2014
- Messages
- 18
Probably a poor title.
I have a very detailed scheduling report that changes frequently. Name: Schedule|Key = TID. TableID=tblSchedule; report = rtpSchedule
I need to email these schedules to the owners of the TID.
The owners of the TID are in another tblTermList.
tblTermlist|CT1TID= rtpSchedule.TID
I need a process that loops through all of the records in tblTermList, and generates the like records from rtpSchedule, opens or generates the report as an attachment (PDF) and sends the report to the owners email address in the tblTermlist.
Caveat; I'm poor with VBA, but getting there. I have researched this forum and the net and found things close, but no cigar or could not make sense out of them because of the lack of definition with the VBA.
Any suggestions would be greatly appreciated.
Also - if this is there is a better forum for this, please let me know.
Thank you to anyone in advance for you time and patience!
I have a very detailed scheduling report that changes frequently. Name: Schedule|Key = TID. TableID=tblSchedule; report = rtpSchedule
I need to email these schedules to the owners of the TID.
The owners of the TID are in another tblTermList.
tblTermlist|CT1TID= rtpSchedule.TID
I need a process that loops through all of the records in tblTermList, and generates the like records from rtpSchedule, opens or generates the report as an attachment (PDF) and sends the report to the owners email address in the tblTermlist.
Caveat; I'm poor with VBA, but getting there. I have researched this forum and the net and found things close, but no cigar or could not make sense out of them because of the lack of definition with the VBA.
Any suggestions would be greatly appreciated.
Also - if this is there is a better forum for this, please let me know.
Thank you to anyone in advance for you time and patience!
