Patti,
Don't give up. Jim has offered me some suggestions to look for. He has it working. I just need to clear my slate a little. From: "'Patti Jakusz' via RBASE-L" <[email protected]> To: "[email protected]" <[email protected]> Date: Wed, 3 Feb 2021 01:20:07 +0000 (UTC) Subject: Re: [RBASE-L] - Help - first time sending report via email Just last week, our system admin installed X5E on all the computers. (By now, I forgot how to convert the databases.) I'm not sure we are going to buy Rmail because I am turning in my notice next year and we have to get them a new database, probably something other Healthy Start sites are using, though they are terrible, I'm starting a different thread with a new question, printing to a URL on OneDrive. Patti On Friday, January 29, 2021, 10:44:04 PM EST, 'Jim Belisle' via RBASE-L <[email protected]> wrote: We have office 365 and use RMAIL. It took a little trial and error but we got it to work. We use version X5E. James Belisle Making Information Systems People Friendly Since 1990 From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Friday, January 29, 2021 10:54 AM To: [email protected] Subject: Re: [RBASE-L] - Help - first time sending report via email CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. I looked in my notes document, and I saved this from 2016: Claudine reports in 2016 that the print/email on does not work with email from Office365. Per Razzak, it won’t work because you cannot specify the port within the print, only by setting up Rmail. One of the Office365 email requirements for integration with third-party applications, in this case R:BASE, is Transport Layer Security (TLS) and Secure Sockets Layer (SSL) support, specifically with port 587. The option to specify TLS/SSL email security protocol is not available in the R:BASE PRINT command at this time, and is only available within R:Mail. Karen -----Original Message----- From: 'Patti Jakusz' via RBASE-L <[email protected]> To: [email protected] <[email protected]> Sent: Fri, Jan 29, 2021 10:42 am Subject: Re: [RBASE-L] - Help - first time sending report via email Hi Karen, Dan sent me this list also, but he had Authentication on. I tried it your way, with "Off". Still didn't work. IT doesn't even go all the way thru to give me the dialog box. Jan said it might be a problem with office365. I will see if our tech guy can help with that. Patti On Friday, January 29, 2021, 11:14:09 AM EST, 'Karen Tellef' via RBASE-L <[email protected]> wrote: 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. -- 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/438922200.154762.1611938569652%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/479251941.189788.1611939234189%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/CH2PR02MB682159997E989CD533D42931A0B89%40CH2PR02MB6821.namprd02.prod.outlook.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/919704566.1268280.1612315207109%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/WC20210203115432.060010%40jjcalibrations.com.
