BookmarkSubscribeRSS Feed
hk2013
Fluorite | Level 6

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.

 
5 REPLIES 5
hk2013
Fluorite | Level 6

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

hk2013
Fluorite | Level 6

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
PROC Star

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
Super User

@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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 950 views
  • 0 likes
  • 3 in conversation