Apologies for hounding this forum on this topic, but I feel I am very close to solving it and hopefully it would be able to help other people in the future if I can get it figured out.
Goal: Email almost 100 selected invoices to my email, from there I download and zip them and send to the customer who requested them.
I'm pretty much have two routes that I have gone down:
1) I have my saved searched of all the invoices I need. I have the work flow that grabs the saved search and then have the action to send email- to my own email (where I will download the attached invoices and compile them into zips for ease of the customer). My problem is that the workflow doesn't email me all the invoices, it will only send me like 5 out of 75. Not sure what could be causing this? Both the saved search and Workflow are on transaction record type.
2) I tested with a mass update. The mass update sends me everything I need (Great!), but it sends it to the email attached to the record not to the customer email or allow me to put a custom email (not great!). Is there a way within mass update to send to a single new email? I guess another option would be to update all the email addresses of the invoices to mine, and then mass update email that way, and then mass change the emails back to their appropriate email. A little clumsy that way and I hate messing with the records in such a way.
Does anyone have a possible solution to either of these two routes?