Hello,
First, I have only basic knowledge of Access. I can do pretty much anything that doesn't require code. I have reports that I run that are e-mailed to individuals. Basically, I assign trouble tickets to users. At the end of the day, I click a button which, when Outlook is open, prompts me for my query criteria (user's name and the date of the tickets I want to have on the report). It then prompts me for the report format (I always choose RTF) and opens an new Outlook e-mail and attaches the RTF report to the e-mail. I then enter the e-mail address in the TO: field, enter a generic subject (always the same) and hit SEND. The problem is that I have to do this for every user. I would like to have a button that I click once. It would then prompt me for the date range (as it does now), then check a table of usernames and e-mail addresses and send a report to every person on the table without my having to hit anything else. I would need to automatically choose RTF, open the e-mail, insert the correct e-mail address for the user in question, insert a generic subject line, and send the e-mail. If there is any coding required for this, I can always cut and paste it (making minor obvious modifications such as "insert generic subject line here"
, but I probably won't understand it very well. I realize that this is probably a complex issue and would appreciate any help you could give me. Thank you.
First, I have only basic knowledge of Access. I can do pretty much anything that doesn't require code. I have reports that I run that are e-mailed to individuals. Basically, I assign trouble tickets to users. At the end of the day, I click a button which, when Outlook is open, prompts me for my query criteria (user's name and the date of the tickets I want to have on the report). It then prompts me for the report format (I always choose RTF) and opens an new Outlook e-mail and attaches the RTF report to the e-mail. I then enter the e-mail address in the TO: field, enter a generic subject (always the same) and hit SEND. The problem is that I have to do this for every user. I would like to have a button that I click once. It would then prompt me for the date range (as it does now), then check a table of usernames and e-mail addresses and send a report to every person on the table without my having to hit anything else. I would need to automatically choose RTF, open the e-mail, insert the correct e-mail address for the user in question, insert a generic subject line, and send the e-mail. If there is any coding required for this, I can always cut and paste it (making minor obvious modifications such as "insert generic subject line here"
, but I probably won't understand it very well. I realize that this is probably a complex issue and would appreciate any help you could give me. Thank you.![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
