combine two codes

[hk2013]

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.

[Kurt_Bremser]

Run the excel export code before you send email "one", and use the attach= option there in the filename email.

[hk2013]

how will the email (code 1) know to attach the excel file that matches the same name? 

[hk2013]

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. 

[SASKiwi]

To dynamically email different recipients with different attachments you will need to use PUT statement email directives. This link to the documentation explains directives:

http://support.sas.com/documentation/cdl/en/lestmtsref/63323/HTML/default/viewer.htm#n0ig2krarrz6vtn...

[Kurt_Bremser]

---

@hk2013 wrote:

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.