11-28-2017 03:39 PM - edited 06-20-2018 07:30 PM
I have this code that send out email with text in the email from a email address found in the data pulled (code 1)and i have another code that makes a excel file for each email/person and email that(code 2) what I want to do is match the email/names in both codes and attach the excel file from code 2 to code 1 email and get rid of the email in code 2 all together.
11-29-2017 02:43 AM
Run the excel export code before you send email "one", and use the attach= option there in the filename email.
12-30-2017 04:51 PM
To dynamically email different recipients with different attachments you will need to use PUT statement email directives. This link to the documentation explains directives:
01-02-2018 05:28 AM
is there code that can tell the email to match the email address or names so that it only gets data and excel file for a specific person and sents that out.
First, set up a list of recipients in a dataset.
Then, wrap your code(s) in macro definitions where the recipient is accepted as a macro parameter.
Now you can use call execute() to call your macro(s) from the recipients dataset.