Creating emails with an attachment for multiple records
I am trying to write a script that will create an individual email for every record I have that will be sent directly to the right contact person for that record and will attach an excel file with only that specific records data.
I know how to create an individual script that exports the record's data and then creates an email and pulls that exported file and looks up the contact's email address to create the email, but using this method I would have to create a seperate script for each record.
How do I go about creating one script that will do this for every record in my database?
Thanks in advance for your help!