Karen I am with you on using the report as the body in the emails. I have gotten pressure to do it but have not found an automated way.
Maybe an enhancement to the print command? Maybe something like “embedreportinbody on” Print invoice option email on |embedreportinbody on | ….. Now that would be nice! Dan Goldberg From: karentellef via RBASE-L [mailto:[email protected]] Sent: Friday, May 13, 2016 7:32 AM To: [email protected] Subject: Re: [RBASE-L] - body contains information Jim: Have you used the "print" statement using "email on"? For that, you don't need RMail. This only works if you have an RBase report to print (you print it as a PDF file), and you get to include a message. In case you don't have the syntax, here's the basics. It does require you to setup individual workstations to enter email server information, or you embed the info right in the "print" command. PRINT Invoice WHERE blno = .vblno OPTION PDF | FILENAME c:\temp\Invoice.pdf + |OPEN OFF + |email ON + |email_to_list &vtoadd + |email_from_name My Company - Boston Division + |email_from_address &vfrom + |Email_subject &vsubject + |email_body &vames If you embed server info, you add these: |EMAIL_HOST mail.yourmailserver.com + |EMAIL_USERID johndoe + |EMAIL_PASSWORD your_smtp_password + |EMAIL_PORT 25 + Karen -----Original Message----- From: Jim Belisle <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[email protected]>> Sent: Thu, May 12, 2016 8:31 pm Subject: RE: [RBASE-L] - body contains information I appreciate all the input. I kind of figured apart from RMAIL it would be quite a task. We do not have RMAIL so we either have to get it or stay with what we have. I have been able to construct simple email bodies with the SELECT LISTOF function but that would not work with this. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: karentellef via RBASE-L [mailto:[email protected]<mailto:[email protected]?>] Sent: Thursday, May 12, 2016 4:16 PM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - body contains information Jim: We discussed this not too long ago on the list. Unless you know html to construct the code to write a detailed RMail email body, there isn't a "simple" way to get a nice designed RBase report to appear as the body of an email (if that is what you're asking). I mentioned that what I did was to print an RBase report to an .RTF file with "optimization ease_of_editing" and then launch it. It comes up in Word. The user is actually able to do a copy-all and paste it right into the email body within their email client. It comes out surprising good! But yeah, if you're just trying to get a simple list, I usually just create a text file that has whatever I need formatted how I want it, and then use RMail's "load from file" to include it as the email body Karen -----Original Message----- From: jan johansen <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[email protected]>> Sent: Thu, May 12, 2016 3:35 pm Subject: RE: [RBASE-L] - body contains information Jim, I'm with Buddy on this one. However, I would tell the production manager that it could be done but this method was chosen for archival purposes. Other wise, if the first two options are not available, you could try creating a NOTE variable, run a cursor through your multiple appending a <cr> to each line. Then use the NOTE as your email body. Jan -----Original Message----- From: "Buddy Walker" <[email protected]<mailto:[email protected]>> To: <[email protected]<mailto:[email protected]>> Date: Thu, 12 May 2016 16:15:50 -0400 Subject: RE: [RBASE-L] - body contains information Jim I would use R:Mail for this. Buddy From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Jim Belisle Sent: Thursday, May 12, 2016 3:28 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - body contains information I create a pdf for certain items we order and send them to the production manager for viewing. He would like for the same information to come as part of the body of the email rather than as a pdf. Since we are talking multiple lines from within a table, what would be the best way to accomplish this goal? James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] -- 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]>. For more options, visit https://groups.google.com/d/optout. -- 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]>. For more options, visit https://groups.google.com/d/optout. -- 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]>. For more options, visit https://groups.google.com/d/optout. -- 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]>. For more options, visit https://groups.google.com/d/optout. -- 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]>. For more options, visit https://groups.google.com/d/optout. -- 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]>. For more options, visit https://groups.google.com/d/optout. -- 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]. For more options, visit https://groups.google.com/d/optout.
