Don't know if this will help, but here's an example of what I use. I am passing in a bunch of variables (email host info is looked up). BTW you don't have to repeat the filename as an "attachment"
PRINT invemail WHERE billto = .vblto + OPTION PDF | FILENAME &vfilename + |EMAIL ON + |EMAIL_AUTHENTICATION OFF + |EMAIL_HOST &gEmailHost + |EMAIL_PORT 25 + |EMAIL_USERID &gEmailUser + |EMAIL_PASSWORD &gEmailPass + |EMAIL_TO_LIST &vtoadd + |EMAIL_FROM_ADDRESS &vfrom + |EMAIL_SUBJECT &vsubject + |EMAIL_BODY &vames + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG OFF Karen -----Original Message----- From: 'Patti Jakusz' via RBASE-L <[email protected]> To: [email protected] <[email protected]>; RBASE-L <[email protected]> Sent: Fri, Jan 29, 2021 9:53 am Subject: [RBASE-L] - Help - first time sending report via email Hello Everyone, For the first time, I'm trying to have our database send reports as email attachments. I set up our email account and can send and receive messages. I set up our server info in Rbase Report Settings. Tested and works ok. (see snip attached) I have a command file that prints the report and is supposed to send it to the email address, but it doesn't. I get a dialog box so I think the command file worked far enough along to get to the end. But I don't get any error message and I don't get an email - not in the inbox of one address or the sent box of the other address. I don't know how to troubleshoot. I attached my command file below. Can anyone help? PRINT NurseRfrlOutcome whe Casenum='30109' and IDO13bor=1 + OPTION PDF|FILENAME L:\Letter\pj30109.PDF + |EMAIL ON + |EMAIL_TO_LIST [email protected] + |EMAIL_FROM_ADDRESS [email protected] + |EMAIL_SUBJECT referral for nurse + |EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! + |EMAIL_ATTACHMENTS L:\Letter\pj30109.PDF + |EMAIL_DELETE_AFTER_SEND OFF + |EMAIL_SHOW_DIALOG ON -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2123626015.163953.1611935622005%40mail.yahoo.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1222495081.176804.1611936846256%40mail.yahoo.com.
