On Mon, 11 Aug 2008 13:44:54 -0700, JT <Railfan1975@GMAIL.COM> wrote:

>First off, I'm using SAS Enterprise Guide 4 and my data files are on a >Unix server. > >I've created a set of global variables to use in my code. I have two >variables EmailAdd and ExcelDir that I am using. > >Here's problem number 1. When I put the EmailAdd variable in a PUT '! >EM_TO!' statement, it will not resolve the variable. I've tried PUT '! >EM_TO! &EmailAdd.', PUT '!EM_TO!' &EmailAdd. and several other >variations and no luck. > >Problem number 2. When I try to do multiple attachments in the PUT '! >EM_ATTACH!' statement, it either will not resolve the variable >ExcelDir or it thinks the multiple attachments are one file name. >I've tried putting parenthesis around the names, spaces between them >and commas between them. No luck, and the help file is no good >either. > >Any help at all is appreicated. > >Thanks! > >Jonathan

I suspect that your problem has nothing to do with the intricacies of the PUT statement and the EMAIL Access Method.

Macro variables will not resolve inside a character literal bounded by single quotes. Use double quotes; to specify a double quote as part of the literal, repeat it, as in

"!em_attach! (""&ExcelDir\a.xls"" ""&ExcelDir\b.xls"")"