tocmo0nlord Posted November 16, 2008 Report Share Posted November 16, 2008 A file gets created every day with a previous date as the file name and other wording on it. ex "BAD_11_13_08.xls" I need to insert that file in a variable and send it over an attachment, how can this be done? Email settings are configured in macro express. Quote Link to comment Share on other sites More sharing options...
kevin Posted November 17, 2008 Report Share Posted November 17, 2008 Do this to create the filename and email the attachment: Date/Time: Save "mm_dd_yy" into %T1% Variable Set String %T1% "BAD_%T1%.xls" E-Mail Send: Know Recipients, Fixed Text, Attachments Copy and paste this into your macro: <DT:mm_dd_yyT:01:3:{P00001}{P00000}{P00000}{P00000}><TVAR2:01:01:BAD_%T1%.xls><EMAIL2:Center:Center:Center:Center:Center:Center:RNR1TOsomeone@someplace.com|someone@someplace.com;S1Report from yesterdayAttached is the report from yesterdayA2%T1%;F> Quote Link to comment Share on other sites More sharing options...
tocmo0nlord Posted November 17, 2008 Author Report Share Posted November 17, 2008 Pretty freaking awesome! thanks! now i just have to sit at work LOL Quote Link to comment Share on other sites More sharing options...
tocmo0nlord Posted November 19, 2008 Author Report Share Posted November 19, 2008 Do this to create the filename and email the attachment: Date/Time: Save "mm_dd_yy" into %T1% Variable Set String %T1% "BAD_%T1%.xls" E-Mail Send: Know Recipients, Fixed Text, Attachments Copy and paste this into your macro: <DT:mm_dd_yyT:01:3:{P00001}{P00000}{P00000}{P00000}><TVAR2:01:01:BAD_%T1%.xls><EMAIL2:Center:Center:Center:Center:Center:Center:RNR1TOsomeone@someplace.com|someone@someplace.com;S1Report from yesterdayAttached is the report from yesterdayA2%T1%;F> eerr, the file will be in a specific folder //folder/file.xls how can it find it ? Quote Link to comment Share on other sites More sharing options...
tocmo0nlord Posted November 19, 2008 Author Report Share Posted November 19, 2008 eerr, the file will be in a specific folder //folder/file.xls how can it find it ? <REM2:List><DT:yyyyT:01:3:{P00001}{P00000}{P00000}{P00000}><DT:MmmmmT:02:3:{P00001}{P00000}{P00000}{P00000}><DT:mmddT:03:3:{P00002}{P00000}{P00000}{P00000}><TVAR2:04:01:\\server\%T1%\%T2\FILES\BAD%T3%_meh.xls><EMAIL2:Center:Center:Center:Center:Center:Center:RYR1TOcarlos.garcia@eh.org|c arlos.garcia@eh.org;S1FileA2%T4%;F><DIS:<REM2:eeep><DIS:<DT:mmddT:01:3:{P00001}{P00000}{P00000}{P00000}><DIS:<TVAR2:01:01:BAD%T1%_meh.xls><DIS:<EMAIL2:Center:Center:Center:Center:Center:Center:RYR1TOcarlos.garcia@eh.org|c arlos.garcia@eh.org;S1eeeptA2%T2%;F> I got this so far, send out the email but no attachment. Quote Link to comment Share on other sites More sharing options...
tocmo0nlord Posted November 19, 2008 Author Report Share Posted November 19, 2008 er, i must have screwed up with the first and second string because i removed them and it works.. Quote Link to comment Share on other sites More sharing options...
tocmo0nlord Posted November 19, 2008 Author Report Share Posted November 19, 2008 How would macro express identify November? i have tried Mmmm MMMM Mmmmm Mm but none work. Quote Link to comment Share on other sites More sharing options...
tocmo0nlord Posted November 19, 2008 Author Report Share Posted November 19, 2008 meh.. got it. mmmm Quote Link to comment Share on other sites More sharing options...
zoobiewa Posted December 10, 2008 Report Share Posted December 10, 2008 meh.. got it. mmmm I'd love to see your end working code. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.