Recurring Schedule for Company Emails

[mlrainsford (Mitchell Rainsford)]

@knash

First I would create a BAQ report. Then you could schedule it like I mentioned above.

I don’t think this will work for my specific situation because I can’t send the email dynamically to a user, the email address has to be set before. Is it possible to dynamically declare a User’s email address?

@AndrewF

BPM Email with embedded BAQ results

Would this be set to a recurring schedule? I read a post earlier that said the overlying BO would have to be accessed in order for the BPM to be run.

@AndrewF

Have SQL send the email with the tasks

I’m unsure of what you mean by have SQL send the email.

@AndrewF

If you want something fancy with hyper-links, then you could write a server process to pull the data and send the emails

I’m leaning towards this option if I’m unable to find a viable option within Epicor.

@AndrewF

You could also schedule this in SSRS

Or you can do a BAQ report and schedule that through epicor.

I’m running into the same issue as I did with @knash 's post here. I’m not able to dynamically set the email recipient.

Thanks again for all the help, this has been a great learning experience so far.