I am glad. One more note. I have added the FROM to be the USER's email address and BCC to the USER's email address, and our SUBJECT lines begin with "BB:" so that in all our users email accounts, we have a RULE that moves all emails with SUBJECT starting with "BB:" into the :SENT ITEMS - RBASE" folder.
This way all the Users can see ALL emails that were sent from within the Rbase Application in their Email Clients. Our users love it and have stopped asking us... What emails did I send out today from the Rbase App? lol Its a VERY easy EMAIL integration that works with Rbase and ANY email system in the world, as long as they have RULES ________________________________ From: [email protected] <[email protected]> on behalf of Doug Hamilton <[email protected]> Sent: Friday, April 11, 2025 1:55 PM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - Print EMAIL - can't get it to work Thank you Robert. Your code worked on my 10.5 system with appropriate modifications. I suspect I may not have correct host and UserID info for client's system. Doug On 4/9/2025 10:31 AM, RDA Technician wrote: Hello We are still on 10.5 (hopefully upgrading VERY soon!!!) We use this Print to email every day in many menu options in our programs. This is what we do: PRINT InvoiceEM WHERE INVOICE# = .vInvoice# + OPTION PDF | FILENAME .vPDFName + |EMAIL ON + |EMAIL_TO_LIST .vInvEmailAddress + |EMAIL_BCC_LIST .vBCCList + |EMAIL_FROM_NAME MyCompany + |EMAIL_FROM_ADDRESS .vfrom_email + |EMAIL_SUBJECT .vSubject + |EMAIL_BODY .vBody + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_ATTACHMENTS .vAttachment + |EMAIL_HOST .vEmail_Host + |EMAIL_AUTHENTICATION .vEmail_Authentication + |EMAIL_PORT .vEmail_Port + |EMAIL_USERID .vEmail_Userid + |EMAIL_PASSWORD .vEmail_Password + |EMAIL_SHOW_DIALOG OFF + |SHOW_CANCEL_DIALOG OFF I changed most variables names to match yours. We do this every time to make certain the parameters are good. Dont forgot to also set your Email Server RELAY settings to allow your IP(s) of the machine(s) emailing this, as well as possible setting the RATE CONTROL in your EMAIL / ANTI SPAM FW to have an exception if you do mass mailings. Hope that works, Robert >>> Doug Hamilton <[email protected]><mailto:[email protected]> 4/7/2025 2:51 >>> PM >>> Version 10.5 - I knew I'd forget something :) On 4/7/2025 1:50 PM, Doug Hamilton wrote: > Hi List - I'm unable to get PRINT reportname EMAIL to work. > > I've set the parameters in Settings > Report Designer > E-Mail > Settings > Report E-Mail Settings > I can Test and get Connection Established! > > As a side question: Having done that, are some of the email parameters > required? > e.g. EMAIL_AUTHENTICATION, EMAIL_HOST, EMAIL_PORT, EMAIL_USERID etc > Or are these used to override what is set in the Report E-Mail Settings? > > Back to the main issue: > The stripped PRINT command I'm using is: > > PRINT InvoiceEM + > WHERE INVOICE# = .vInvoice# + > OPTION PDF|FILENAME .vPDFName + > |EMAIL ON + > |EMAIL_TO_LIST .vInvEmailAddress + > |EMAIL_SUBJECT .vSubject + > |EMAIL_BODY .vBody + > |EMAIL_FROM_NAME MyCompany + > |EMAIL_SHOW_DIALOG ON > > All variables are properly defined, I've replaced the EMAIL_TO_LIST > variable with my hardcoded email address. > The PDF Filename is created and is in the current directory. > Everything in the Email Dialog prior to sending looks ok. > > Does the computer on which I'm testing need to have an email client on > it? > > TIA, > Doug > -- This email has been checked for viruses by Avast antivirus software. www.avast.com<http://www.avast.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]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/95173e1a-c785-4c9d-a518-905ecfa5946e%40wi.rr.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]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/67F692ED0200001D00007743%40mail.mrsbaking.com<https://groups.google.com/d/msgid/rbase-l/67F692ED0200001D00007743%40mail.mrsbaking.com?utm_medium=email&utm_source=footer>. [https://s-install.avcdn.net/ipm/preview/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Virus-free.www.avast.com<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> -- 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]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/2f0e8de6-1d8f-4f10-b655-8559f2cee22b%40wi.rr.com<https://groups.google.com/d/msgid/rbase-l/2f0e8de6-1d8f-4f10-b655-8559f2cee22b%40wi.rr.com?utm_medium=email&utm_source=footer>. ________________________________ From: [email protected] <[email protected]> on behalf of Doug Hamilton <[email protected]> Sent: Friday, April 11, 2025 1:55 PM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - Print EMAIL - can't get it to work Thank you Robert. Your code worked on my 10.5 system with appropriate modifications. I suspect I may not have correct host and UserID info for client's system. Doug On 4/9/2025 10:31 AM, RDA Technician wrote: Hello We are still on 10.5 (hopefully upgrading VERY soon!!!) We use this Print to email every day in many menu options in our programs. This is what we do: PRINT InvoiceEM WHERE INVOICE# = .vInvoice# + OPTION PDF | FILENAME .vPDFName + |EMAIL ON + |EMAIL_TO_LIST .vInvEmailAddress + |EMAIL_BCC_LIST .vBCCList + |EMAIL_FROM_NAME MyCompany + |EMAIL_FROM_ADDRESS .vfrom_email + |EMAIL_SUBJECT .vSubject + |EMAIL_BODY .vBody + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_ATTACHMENTS .vAttachment + |EMAIL_HOST .vEmail_Host + |EMAIL_AUTHENTICATION .vEmail_Authentication + |EMAIL_PORT .vEmail_Port + |EMAIL_USERID .vEmail_Userid + |EMAIL_PASSWORD .vEmail_Password + |EMAIL_SHOW_DIALOG OFF + |SHOW_CANCEL_DIALOG OFF I changed most variables names to match yours. We do this every time to make certain the parameters are good. Dont forgot to also set your Email Server RELAY settings to allow your IP(s) of the machine(s) emailing this, as well as possible setting the RATE CONTROL in your EMAIL / ANTI SPAM FW to have an exception if you do mass mailings. Hope that works, Robert >>> Doug Hamilton <[email protected]><mailto:[email protected]> 4/7/2025 2:51 >>> PM >>> Version 10.5 - I knew I'd forget something :) On 4/7/2025 1:50 PM, Doug Hamilton wrote: > Hi List - I'm unable to get PRINT reportname EMAIL to work. > > I've set the parameters in Settings > Report Designer > E-Mail > Settings > Report E-Mail Settings > I can Test and get Connection Established! > > As a side question: Having done that, are some of the email parameters > required? > e.g. EMAIL_AUTHENTICATION, EMAIL_HOST, EMAIL_PORT, EMAIL_USERID etc > Or are these used to override what is set in the Report E-Mail Settings? > > Back to the main issue: > The stripped PRINT command I'm using is: > > PRINT InvoiceEM + > WHERE INVOICE# = .vInvoice# + > OPTION PDF|FILENAME .vPDFName + > |EMAIL ON + > |EMAIL_TO_LIST .vInvEmailAddress + > |EMAIL_SUBJECT .vSubject + > |EMAIL_BODY .vBody + > |EMAIL_FROM_NAME MyCompany + > |EMAIL_SHOW_DIALOG ON > > All variables are properly defined, I've replaced the EMAIL_TO_LIST > variable with my hardcoded email address. > The PDF Filename is created and is in the current directory. > Everything in the Email Dialog prior to sending looks ok. > > Does the computer on which I'm testing need to have an email client on > it? > > TIA, > Doug > -- This email has been checked for viruses by Avast antivirus software. www.avast.com<http://www.avast.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]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/95173e1a-c785-4c9d-a518-905ecfa5946e%40wi.rr.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]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/67F692ED0200001D00007743%40mail.mrsbaking.com<https://groups.google.com/d/msgid/rbase-l/67F692ED0200001D00007743%40mail.mrsbaking.com?utm_medium=email&utm_source=footer>. [https://s-install.avcdn.net/ipm/preview/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Virus-free.www.avast.com<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> -- 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]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/2f0e8de6-1d8f-4f10-b655-8559f2cee22b%40wi.rr.com<https://groups.google.com/d/msgid/rbase-l/2f0e8de6-1d8f-4f10-b655-8559f2cee22b%40wi.rr.com?utm_medium=email&utm_source=footer>. -- 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 visit https://groups.google.com/d/msgid/rbase-l/SA1PR19MB5182709CBFCC76B405A3C23FA8B62%40SA1PR19MB5182.namprd19.prod.outlook.com.
