Unanswered: Pass email address from table to macro?
I'd like to store the email addresses of my customer service reps in a table. When a job comes in from a customer who is assigned to a certain rep, I'd like that rep to receive an email which contains a snapshot report with the details of the order on it.
Right now I am using a macro to generate a snapshot report and send it, but I have to hardcode an email address into the macro.
Any ideas on how to do this? We use an MS Exchange server. We were going to use CDO code but are having a lot of trouble getting it to work. I'd probably just rather do this by looking up the email and then sending the snapshot.