Re: [RBASE-L] - email novice problems

['jim schmitt' via RBASE-L]

 Hi, Karen:
Thanks for the sample.I guess i missed it, and thought that the print 
command with email on and options could figure out the host/port/authentication 
issue on its own.   but, not true.  I guess I'll have to mess with the email to 
determine the settings, which I have never done.    Thanks again.
Jim 
On Saturday, November 11, 2023 at 08:50:59 AM EST, 'Karen Tellef' via 
RBASE-L  wrote:  
 
  Here's a copy of code that runs fine every day (all data is sent in by 
variables).  Perhaps compare to your code and see what the differences are?  
It's been a long time since I've messed with this code; we embedded the 
host/port/authentication within the print itself for some reason rather than 
doing the settings.  We store the settings within a table.  I think it was just 
for ease rather than remembering to do report email settings with new RBase 
installs

Karen

PRINT invemail WHERE billdate = .#DATE OPTION PDF|FILENAME  +
 |EMAIL ON +
 |EMAIL_AUTHENTICATION OFF +
 |EMAIL_HOST  +
 |EMAIL_PORT 25 +
 |EMAIL_USERID  +
 |EMAIL_PASSWORD  +
 |EMAIL_TO_LIST  +
 |EMAIL_FROM_NAME Boston Division +
 |EMAIL_FROM_ADDRESS  +
 |EMAIL_SUBJECT  +
 |EMAIL_BODY  +
 |EMAIL_DELETE_AFTER_SEND ON +
 |EMAIL_SHOW_DIALOG OFF

On Friday, November 10, 2023 at 04:52:49 PM CST, 'jim schmitt' via RBASE-L 
 wrote:  
 
 Greeting fellow R:base users:
You may be able to offer some blues clues for me.This is my first attempt at 
trying to send a report via email:
Using RB Version X5E  10.5.4 20646

Tried using Razzak's sample in RRBYW20 - code listed below:
PRINT Invoice WHERE TransID = 1031 +OPTION PDF|FILENAME Invoice_1031.PDF 
+|EMAIL ON +|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. 
Johnson +|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The 
Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because 
we Can! +|EMAIL_DELETE_AFTER_SEND ON +|EMAIL_SHOW_DIALOG ONreturn

If I try it with just the first two lines, it works and creates the PDF file 
which I can see..With the email options, I get nothing ??Just can't see what I 
am missing.any help would be appreciated. The report email settings listed  
below:


Thanks in advance.Jim

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1074275864.2200889.1699656760734%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2067692558.1858400.1699710651612%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1872682227.3620598.1699989282797%40mail.yahoo.com.

Re: [RBASE-L] - email novice problems

['jim schmitt' via RBASE-L]

 Thanks, Karen:
I will try this later on today.
On Saturday, November 11, 2023 at 08:50:59 AM EST, 'Karen Tellef' via 
RBASE-L  wrote:  
 
  Here's a copy of code that runs fine every day (all data is sent in by 
variables).  Perhaps compare to your code and see what the differences are?  
It's been a long time since I've messed with this code; we embedded the 
host/port/authentication within the print itself for some reason rather than 
doing the settings.  We store the settings within a table.  I think it was just 
for ease rather than remembering to do report email settings with new RBase 
installs

Karen

PRINT invemail WHERE billdate = .#DATE OPTION PDF|FILENAME  +
 |EMAIL ON +
 |EMAIL_AUTHENTICATION OFF +
 |EMAIL_HOST  +
 |EMAIL_PORT 25 +
 |EMAIL_USERID  +
 |EMAIL_PASSWORD  +
 |EMAIL_TO_LIST  +
 |EMAIL_FROM_NAME Boston Division +
 |EMAIL_FROM_ADDRESS  +
 |EMAIL_SUBJECT  +
 |EMAIL_BODY  +
 |EMAIL_DELETE_AFTER_SEND ON +
 |EMAIL_SHOW_DIALOG OFF

On Friday, November 10, 2023 at 04:52:49 PM CST, 'jim schmitt' via RBASE-L 
 wrote:  
 
 Greeting fellow R:base users:
You may be able to offer some blues clues for me.This is my first attempt at 
trying to send a report via email:
Using RB Version X5E  10.5.4 20646

Tried using Razzak's sample in RRBYW20 - code listed below:
PRINT Invoice WHERE TransID = 1031 +OPTION PDF|FILENAME Invoice_1031.PDF 
+|EMAIL ON +|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. 
Johnson +|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The 
Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because 
we Can! +|EMAIL_DELETE_AFTER_SEND ON +|EMAIL_SHOW_DIALOG ONreturn

If I try it with just the first two lines, it works and creates the PDF file 
which I can see..With the email options, I get nothing ??Just can't see what I 
am missing.any help would be appreciated. The report email settings listed  
below:


Thanks in advance.Jim

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1074275864.2200889.1699656760734%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2067692558.1858400.1699710651612%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/195320199.2340903.1699712187530%40mail.yahoo.com.

Re: [RBASE-L] - email novice problems

['Karen Tellef' via RBASE-L]

 Here's a copy of code that runs fine every day (all data is sent in by 
variables).  Perhaps compare to your code and see what the differences are?  
It's been a long time since I've messed with this code; we embedded the 
host/port/authentication within the print itself for some reason rather than 
doing the settings.  We store the settings within a table.  I think it was just 
for ease rather than remembering to do report email settings with new RBase 
installs

Karen

PRINT invemail WHERE billdate = .#DATE OPTION PDF|FILENAME  +
 |EMAIL ON +
 |EMAIL_AUTHENTICATION OFF +
 |EMAIL_HOST  +
 |EMAIL_PORT 25 +
 |EMAIL_USERID  +
 |EMAIL_PASSWORD  +
 |EMAIL_TO_LIST  +
 |EMAIL_FROM_NAME Boston Division +
 |EMAIL_FROM_ADDRESS  +
 |EMAIL_SUBJECT  +
 |EMAIL_BODY  +
 |EMAIL_DELETE_AFTER_SEND ON +
 |EMAIL_SHOW_DIALOG OFF

On Friday, November 10, 2023 at 04:52:49 PM CST, 'jim schmitt' via RBASE-L 
 wrote:  
 
 Greeting fellow R:base users:
You may be able to offer some blues clues for me.This is my first attempt at 
trying to send a report via email:
Using RB Version X5E  10.5.4 20646

Tried using Razzak's sample in RRBYW20 - code listed below:
PRINT Invoice WHERE TransID = 1031 +OPTION PDF|FILENAME Invoice_1031.PDF 
+|EMAIL ON +|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. 
Johnson +|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The 
Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because 
we Can! +|EMAIL_DELETE_AFTER_SEND ON +|EMAIL_SHOW_DIALOG ONreturn

If I try it with just the first two lines, it works and creates the PDF file 
which I can see..With the email options, I get nothing ??Just can't see what I 
am missing.any help would be appreciated. The report email settings listed  
below:


Thanks in advance.Jim

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1074275864.2200889.1699656760734%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2067692558.1858400.1699710651612%40mail.yahoo.com.

Re: [RBASE-L] - email novice problems

['jim schmitt' via RBASE-L]

 Hi, Jim:
Thanks for the suggestion.  I tried the attachment option (code listed below), 
Still - no go.I know this looks easy enough, but it isn't working.   Am i 
missing something ?
SET MESSAGES ONSET ERROR MESSAGES ON
Set var vfilename TEXT = ‘c:\emailtest\_1031.PDF’
PRINT validate  +OPTION PDF|FILENAME Invoice_1031.PDF +|EMAIL ON 
+|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. Johnson 
+|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The 
Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because 
we Can! +|EMAIL_ATTACHMENTS  +|EMAIL_DELETE_AFTER_SEND ON 
+|EMAIL_SHOW_DIALOG ON
return
 
On Friday, November 10, 2023 at 06:53:38 PM EST, 'Jim Belisle' via RBASE-L 
 wrote:  
 
 
Jim,
 
  
 
Try adding a line for the attachment.
 
You may want to set the attachment as a variable with the complete location.
 
Example:
 
Set var vfilename TEXT = ‘complete location_1031.PDF’
 
|EMAIL_ATTACHMENTS 
 
Try something like this and see what happens.
 
  
 
Jim
 
  
 
  
 
From: 'jim schmitt' via RBASE-L 
Sent: Friday, November 10, 2023 4:53 PM
To: rbase group 
Subject: [RBASE-L] - email novice problems
 
  
 
|  | 
CAUTION:This is an EXTERNAL EMAIL,STOP! and think before clicking on any links 
or opening attachments. 
  |


Greeting fellow R:base users:
 
  
 
You may be able to offer some blues clues for me.
 
This is my first attempt at trying to send a report via email:
 
Using RB Version X5E  10.5.4 20646
 
  
 
Tried using Razzak's sample in RRBYW20 - code listed below:
 
  
 
PRINT Invoice WHERE TransID = 1031 +
 
OPTION PDF|FILENAME Invoice_1031.PDF +
 
|EMAIL ON +
 
|email_to_listjim.schm...@yahoo.com +
 
|EMAIL_FROM_NAME John D. Johnson +
 
|email_from_addressjim.schm...@yahoo.com +
 
|EMAIL_SUBJECT Imagine The Possibilities! +
 
|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! +
 
|EMAIL_DELETE_AFTER_SEND ON +
 
|EMAIL_SHOW_DIALOG ON
 
return
 
  
 
If I try it with just the first two lines, it works and creates the PDF file 
which I can see..
 
With the email options, I get nothing ??
 
Just can't see what I am missing.any help would be appreciated.
 
 
 
The report email settings listed  below:
 
  
 

 
Thanks in advance.
 
Jim
 
-- 
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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1074275864.2200889.1699656760734%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/PH7PR02MB994323D03D5F3990B3A1C013A0AEA%40PH7PR02MB9943.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/97081457.2319033.1699709336057%40mail.yahoo.com.

RE: [RBASE-L] - email novice problems

['Jim Belisle' via RBASE-L]

Jim,

Try adding a line for the attachment.
You may want to set the attachment as a variable with the complete location.
Example:
Set var vfilename TEXT = 'complete location_1031.PDF'
|EMAIL_ATTACHMENTS 
Try something like this and see what happens.

Jim


From: 'jim schmitt' via RBASE-L 
Sent: Friday, November 10, 2023 4:53 PM
To: rbase group 
Subject: [RBASE-L] - email novice problems

CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links 
or opening attachments.
Greeting fellow R:base users:

You may be able to offer some blues clues for me.
This is my first attempt at trying to send a report via email:
Using RB Version X5E  10.5.4 20646

Tried using Razzak's sample in RRBYW20 - code listed below:

PRINT Invoice WHERE TransID = 1031 +
OPTION PDF|FILENAME Invoice_1031.PDF +
|EMAIL ON +
|EMAIL_TO_LIST jim.schm...@yahoo.com<mailto:jim.schm...@yahoo.com> +
|EMAIL_FROM_NAME John D. Johnson +
|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com<mailto:jim.schm...@yahoo.com> +
|EMAIL_SUBJECT Imagine The Possibilities! +
|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! +
|EMAIL_DELETE_AFTER_SEND ON +
|EMAIL_SHOW_DIALOG ON
return

If I try it with just the first two lines, it works and creates the PDF file 
which I can see..
With the email options, I get nothing ??
Just can't see what I am missing.any help would be appreciated.

The report email settings listed  below:

[Inline image]
Thanks in advance.
Jim
--
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1074275864.2200889.1699656760734%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/1074275864.2200889.1699656760734%40mail.yahoo.com?utm_medium=email_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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/PH7PR02MB994323D03D5F3990B3A1C013A0AEA%40PH7PR02MB9943.namprd02.prod.outlook.com.

[RBASE-L] - email novice problems

['jim schmitt' via RBASE-L]

Greeting fellow R:base users:
You may be able to offer some blues clues for me.This is my first attempt at 
trying to send a report via email:
Using RB Version X5E  10.5.4 20646

Tried using Razzak's sample in RRBYW20 - code listed below:
PRINT Invoice WHERE TransID = 1031 +OPTION PDF|FILENAME Invoice_1031.PDF 
+|EMAIL ON +|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. 
Johnson +|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The 
Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because 
we Can! +|EMAIL_DELETE_AFTER_SEND ON +|EMAIL_SHOW_DIALOG ONreturn

If I try it with just the first two lines, it works and creates the PDF file 
which I can see..With the email options, I get nothing ??Just can't see what I 
am missing.any help would be appreciated. The report email settings listed  
below:


Thanks in advance.Jim

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1074275864.2200889.1699656760734%40mail.yahoo.com.

Re: [RBASE-L] - eMail table structure

[jan johansen]

Karen,



Nice. Thanks a lot!



Jan







From: "'Karen Tellef' via RBASE-L" 
To: "rbase-l@googlegroups.com" 
Date: Wed, 4 May 2022 16:52:43 + (UTC)
Subject: Re: [RBASE-L] - eMail table structure


Jan:


I have one application with this ability.  The structure was started by 
another programmer, so I don't take full credit.  It isn't perfect, as we 
added features over the years and would've done it differently if I had 
designed it today.


Here's the structure of the table (not all the columns), along with a 
description of what some of the columns are for.  We have a scheduled task 
that runs every 20 minutes, scans the table for "xDateTimeSent is null".  
Cursors thru the rows, sends out using RMail, updates the xDateTimeSent.  
The program that deciphers all the elements is quite complicated.


It was originally set up to send emails to "groups" (ReptGroup).  There's a 
maintenance table that has a group name and a list of email addresses.  So 
different programs will send emails to different "groups" of people (a group 
could have just one person).  Later on, we needed the ability for users to 
send emails to specific people, not a group, so we created an AlertDetail 
table that has the to / from / cc information.


It works really well for us.






  Table: Alert   

CmdFileType   : TEXT 50
   This is the name of the RBase program that created the email
ReptGroup  Type   : TEXT 8
   The group the email is sent to; lookup to another table for email 
addresses
xDateTime  Type   : DATETIME NOT NULL
   When the email was inserted
xDateTimeSent  Type   : DATETIME
   When the email was sent by RMail
AlertSubject   Type   : NOTE
AlertFailedType   : DATETIME
   If RMail failed, date put here
EmailTypeIDType   : INTEGERDefault: 1
   1 = look at ReptGroup, 2 = look at AlertDetail table for email address
AlertEmailType Type   : TEXT 4 Default: TEXT
   This was added when we started using HTML as the body on some emails.  
Would have the word "HTML"
AlertFileAttachType   : TEXT 120
   Name of a file to attach


AlertNote  Type   : NOTE
   If the email body is just a string text, it goes in here
AlertTxtFile   Type   : TEXT 120
   Or the email body can be contained in an external file, either ascii or 
html.  So this would be the filename, like F:\EmailFiles\Orders.txt




Hope this gives you some ideas!!




Karen






-Original Message-
From: jan johansen 
To: rbase-l@googlegroups.com
Sent: Wed, May 4, 2022 10:03 am
Subject: [RBASE-L] - eMail table structure


Greetings,


Was just wondering if anyone had a successful table structure to store 
emails to send, etc
that would be willing to share.


TIA,


Jan


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/WC20220504150311.87010F%40jjcalibrations.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1649618192.3458901.1651683163487%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/WC20220504170350.47013E%40jjcalibrations.com.

Re: [RBASE-L] - eMail table structure

['Karen Tellef' via RBASE-L]

Jan:
I have one application with this ability.  The structure was started by another 
programmer, so I don't take full credit.  It isn't perfect, as we added 
features over the years and would've done it differently if I had designed it 
today. 

Here's the structure of the table (not all the columns), along with a 
description of what some of the columns are for.  We have a scheduled task that 
runs every 20 minutes, scans the table for "xDateTimeSent is null".  Cursors 
thru the rows, sends out using RMail, updates the xDateTimeSent.  The program 
that deciphers all the elements is quite complicated.

It was originally set up to send emails to "groups" (ReptGroup).  There's a 
maintenance table that has a group name and a list of email addresses.  So 
different programs will send emails to different "groups" of people (a group 
could have just one person).  Later on, we needed the ability for users to send 
emails to specific people, not a group, so we created an AlertDetail table that 
has the to / from / cc information.
It works really well for us.



  Table: Alert    

CmdFile    Type   : TEXT 50   This is the name of the RBase program 
that created the email
ReptGroup  Type   : TEXT 8
   The group the email is sent to; lookup to another table for email addresses
xDateTime  Type   : DATETIME NOT NULL   When the email was inserted
xDateTimeSent  Type   : DATETIME   When the email was sent by RMail
AlertSubject   Type   : NOTEAlertFailed    Type   : DATETIME   If RMail 
failed, date put here
EmailTypeID    Type   : INTEGER    Default: 1   1 = look at ReptGroup, 2 = 
look at AlertDetail table for email address
AlertEmailType Type   : TEXT 4 Default: TEXT
   This was added when we started using HTML as the body on some emails.  Would 
have the word "HTML"
AlertFileAttach    Type   : TEXT 120   Name of a file to attach
AlertNote  Type   : NOTE
   If the email body is just a string text, it goes in here
AlertTxtFile   Type   : TEXT 120   Or the email body can be contained in an 
external file, either ascii or html.  So this would be the filename, like 
F:\EmailFiles\Orders.txt
 
 Hope this gives you some ideas!!

Karen

 
-Original Message-
From: jan johansen 
To: rbase-l@googlegroups.com
Sent: Wed, May 4, 2022 10:03 am
Subject: [RBASE-L] - eMail table structure

Greetings, Was just wondering if anyone had a successful table structure to 
store emails to send, etcthat would be willing to share. TIA, Jan-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/WC20220504150311.87010F%40jjcalibrations.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1649618192.3458901.1651683163487%40mail.yahoo.com.

[RBASE-L] - eMail table structure

[jan johansen]

Greetings,



Was just wondering if anyone had a successful table structure to store 
emails to send, etc

that would be willing to share.



TIA,



Jan

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/WC20220504150311.87010F%40jjcalibrations.com.

Re: [RBASE-L] - Email x5

[Rich]

Does rbase need to be installed first?

Rich

Sent from my iPhone

> On Nov 16, 2021, at 2:13 PM, A. Razzak Memon  wrote:
> 
> Rich,
> 
> Be sure the R:Mail X.5 installer was launched with the Administrator account, 
> and the process completed.
> 
> R:Mail may be reinstalled, only using the Administrator account, without 
> having to uninstall the software. Double click the installer file again to do 
> so.
> 
> R:Mail X.5 should then appear in the list of programs installed upon the 
> Windows Server operating system.
> 
> If you are perhaps encountering an issue in some other area, please respond 
> with a great amount of detail in your reply.
> 
> Razzak
> 
> At 11:47 AM 11/16/2021, Rich wrote:
> 
>> Moving to a new server Windows 2019. Ran the setup for rmail it displays the 
>> smtp server but does not install(does not show in the program list) no error 
>> messages
>> What am I missing here?
> 
> 
> -- 
> 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 rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/0LfU6x-1mKw940DQv-00p0pb%40mrelay.perfora.net.
> 

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/80D0BA1C-20D1-4BD6-BA70-32AC9FFB15AC%40ogdengroup.com.

Re: [RBASE-L] - Email x5

[A. Razzak Memon]

Rich,

Be sure the R:Mail X.5 installer was launched with the Administrator 
account, and the process completed.


R:Mail may be reinstalled, only using the Administrator account, 
without having to uninstall the software. Double click the installer 
file again to do so.


R:Mail X.5 should then appear in the list of programs installed upon 
the Windows Server operating system.


If you are perhaps encountering an issue in some other area, please 
respond with a great amount of detail in your reply.


Razzak

At 11:47 AM 11/16/2021, Rich wrote:

Moving to a new server Windows 2019. Ran the setup for rmail it 
displays the smtp server but does not install(does not show in the 
program list) no error messages

What am I missing here?



--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/0LfU6x-1mKw940DQv-00p0pb%40mrelay.perfora.net.

[RBASE-L] - Email x5

[Rich]

Moving to a new server Windows 2019. Ran the setup for rmail it displays the 
smtp server but does not install(does not show in the program list) no error 
messages
What am I missing here?

Rich Jasinski

Sent from my iPhone

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/05581E7D-A9ED-4370-9C57-F43264F123EF%40ogdengroup.com.

[RBASE-L] - EMAIL ANOMALY

['Jim Belisle' via RBASE-L]

Buddy,

Thanks for the mention of the password. Though I never changed the password, 
the administrator checked the password and asked me to try a different one.
Sure enough, the password he gave me worked. I have no idea where things got 
changed since I am the one who runs the configuration file for RMAIL.

I am just glad it is working.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01D6CCAF.FC3D7EC0]

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394D4691D4581751E0EDD1DA0CD0%40CY4PR0201MB3394.namprd02.prod.outlook.com.

[RBASE-L] - Email with attachment

[Lena Dammstrom]

Hi all,
Is there a size limitation in RBaseX version 10.0.4.3 for attachments?
If the PDF size is 3,317KB I receive the email
If the PDF size is 10,091KB I do not get the email

PRINT BreakInsRpt WHERE CustomerBreakinsID = .vbiBreakInID +
  OPTION PDF +
  |FILENAME  +
  |SHOW_CANCEL_DIALOG OFF +
  |EMAIL ON +
  |EMAIL_HOST .vbiESrvHost +
  |EMAIL_USERID .vbiESrvUser +
  |EMAIL_PASSWORD .vbiESrvPass +
  |EMAIL_ATTACHMENTS ' ' +
  |EMAIL_FROM_ADDRESS .vbiEFromAddress +
  |EMAIL_FROM_NAME .vbiEFromName +
  |EMAIL_TO_LIST .vbiEToList +
  |EMAIL_BCC_LIST .vbiEBCCList +
  |EMAIL_SUBJECT .vbiESubject +
  |EMAIL_BODY .vbiEBody +
  |EMAIL_DELETE_AFTER_SEND OFF +
  |EMAIL_SHOW_DIALOG OFF

Any clues would be most appreciated.
Thank you in advance for your time and consideration.

Regards
Lena

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Email

[Steve Johnson]

Dick,

Sorry, I just realized from Javier's message that you indicated only 2 user out 
of X users having a problem sending email, so Javier does have a point that it 
may be related to specific users rather than a port issue.  If outgoing 
passwords are user specific, perhaps it is then a password issue on the 
affected machines.  Since Thunderbird email works on all machines, comparing 
the outgoing settings in Thunderbird on the offending machines with the code in 
Rbase email may reveal something.  Tracing the email code execution may help 
although it is simplistic, at least you can see the variables when they are 
populated.  

Since Rbase basic email uses the un-encrypted Port 25 as default outgoing port, 
you may want to consider using a more secure email connection, which probably 
means using the Rbase Email pluggin, since if I recall correctly, the pluggin 
can send using TLS or SSL to meet the host's requirements.  The pluggin is also 
very useful in testing the email connection during setup or as needed.

Hope this helps,

Steve



-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Javier Valencia
Sent: Wednesday, December 12, 2018 1:16 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Email

Dick,

If only two of your users are having the issue it would appear that is not 
R:Base or e-mail related but user specific. Have the passwords been changed 
recently and not updated in the proper locations? Do the users in question have 
the proper privileges to access files, directories and applications?
Have you tried tracing the code at the offending workstations while monitoring 
variables and verifying they are correct? Most of the time when I have this 
type of issue I trace the code one line at the time and almost always I am able 
to find the offending code or missing/undefined variable.

Javier,

Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Carpet Broker, Dick Fey
Sent: Tuesday, December 11, 2018 4:07 PM
To: RBase Maillist
Subject: [RBASE-L] - Email

This is NOT actually an R:base issue, but is driving us completely nuts.

Many places in our R:base X application automatically sends out emails. 
(invoice, confirmations, etc)
We use the EMAIL ON code in the print command.  All the settings are drawn from 
a user table.
For years all worked fine, now 2 of our users cannot send emails, even though 
there have been no changes to the R:base code, nor to the email program itself. 
 We all use Thunderbird as our E:Mail client.
They have no problem sending or receiving mail directly from Thunderbird.

I have discussed with John Minyo tryng R:Mail, but he doesn't think that's 
going to solve our problem.

Anyone have a suggestion as to where I might look?

Dick Fey
Carpet Broker Inc.

Code is below:

   PRINT  +
   WHERE refnum = .vrefnum  OPTION PDF | ORIENTATION PORTRAIT +
   |FILENAME  +
   |EMAIL ON +
   |EMAIL_HOST mail.thecarpetbroker.COM +
   |EMAIL_USERID  +
   |EMAIL_PASSWORD  +
   |EMAIL_TO_LIST   +
   |EMAIL_BCC_LIST  +
   |EMAIL_FROM_NAME Carpet Broker +
   |EMAIL_FROM_ADDRESS  +
   |EMAIL_SUBJECT   +
   |EMAIL_BODY   +
   |EMAIL_AUTHENTICATION ON +
   |EMAIL_DELETE_AFTER_SEND OFF +
   |EMAIL_SHOW_DIALOG OFF

--
Carpet Broker Inc
P: 913-894-9211
F: 913-894-0138


-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Email

[Javier Valencia]

Dick,

If only two of your users are having the issue it would appear that is not 
R:Base or e-mail related but user specific. Have the passwords been changed 
recently and not updated in the proper locations? Do the users in question have 
the proper privileges to access files, directories and applications?
Have you tried tracing the code at the offending workstations while monitoring 
variables and verifying they are correct? Most of the time when I have this 
type of issue I trace the code one line at the time and almost always I am able 
to find the offending code or missing/undefined variable.

Javier,

Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Carpet Broker, Dick Fey
Sent: Tuesday, December 11, 2018 4:07 PM
To: RBase Maillist
Subject: [RBASE-L] - Email

This is NOT actually an R:base issue, but is driving us completely nuts.

Many places in our R:base X application automatically sends out emails. 
(invoice, confirmations, etc)
We use the EMAIL ON code in the print command.  All the settings are 
drawn from a user table.
For years all worked fine, now 2 of our users cannot send emails, even 
though there have been no changes
to the R:base code, nor to the email program itself.  We all use 
Thunderbird as our E:Mail client.
They have no problem sending or receiving mail directly from Thunderbird.

I have discussed with John Minyo tryng R:Mail, but he doesn't think 
that's going to solve our problem.

Anyone have a suggestion as to where I might look?

Dick Fey
Carpet Broker Inc.

Code is below:

   PRINT  +
   WHERE refnum = .vrefnum  OPTION PDF | ORIENTATION PORTRAIT +
   |FILENAME  +
   |EMAIL ON +
   |EMAIL_HOST mail.thecarpetbroker.COM +
   |EMAIL_USERID  +
   |EMAIL_PASSWORD  +
   |EMAIL_TO_LIST   +
   |EMAIL_BCC_LIST  +
   |EMAIL_FROM_NAME Carpet Broker +
   |EMAIL_FROM_ADDRESS  +
   |EMAIL_SUBJECT   +
   |EMAIL_BODY   +
   |EMAIL_AUTHENTICATION ON +
   |EMAIL_DELETE_AFTER_SEND OFF +
   |EMAIL_SHOW_DIALOG OFF

-- 
Carpet Broker Inc
P: 913-894-9211
F: 913-894-0138


-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Email

[Steve Johnson]

Dick,

My guess is that you might be running into a blocked outgoing port at the email 
host provider.  Port 25 (a legacy Text format port), which is the default port 
in Rbase basic email, is increasingly being blocked by ISP's due to excessive 
spam.  I would check with your email host to see if they are blocking Port 25 
and have enforced SSL or TLS encryption when sending emails, which requires a 
different port setting. You can probably do this on-line at the provider's 
website.  The provider also might indicate an alternate port to Port 25, 
possibly 2025.   Unfortunately, the basic email module within Rbase does not 
have the capability to send email using either TLS or SSL format.  You would 
need to use the Rmail pluggin to do this.But you can change the outgoing 
port number in Rbase:   EMAIL_PORTvalueSpecifies the integer value of 
SMTP Server Port. (Default = 25), but would have to use a different 
un-encrypted port specified by the host.  

Since you indicate that you  can send email out of Thunderbird, you could check 
what the outgoing settings are for the Port number and whether TLS or SSL has 
been chosen, which might help to confirm my suspicions.  Port 587 is typically 
TLS, which is un-encrypted.  Port 465 is typically SSL, which is encrypted.  
Port 25 was the default setting for text only email way back when, but many, if 
not most, email providers now block port 25 due to spam.  

You might want to consider using the Rmail Pluggin so that you can send out 
your email in an encrypted format, if security is of any concern in the data 
being sent. 

Hope this helps,

Steve Johnson




-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Carpet Broker, Dick Fey
Sent: Tuesday, December 11, 2018 5:07 PM
To: RBase Maillist
Subject: [RBASE-L] - Email

This is NOT actually an R:base issue, but is driving us completely nuts.

Many places in our R:base X application automatically sends out emails. 
(invoice, confirmations, etc)
We use the EMAIL ON code in the print command.  All the settings are drawn from 
a user table.
For years all worked fine, now 2 of our users cannot send emails, even though 
there have been no changes to the R:base code, nor to the email program itself. 
 We all use Thunderbird as our E:Mail client.
They have no problem sending or receiving mail directly from Thunderbird.

I have discussed with John Minyo tryng R:Mail, but he doesn't think that's 
going to solve our problem.

Anyone have a suggestion as to where I might look?

Dick Fey
Carpet Broker Inc.

Code is below:

   PRINT  +
   WHERE refnum = .vrefnum  OPTION PDF | ORIENTATION PORTRAIT +
   |FILENAME  +
   |EMAIL ON +
   |EMAIL_HOST mail.thecarpetbroker.COM +
   |EMAIL_USERID  +
   |EMAIL_PASSWORD  +
   |EMAIL_TO_LIST   +
   |EMAIL_BCC_LIST  +
   |EMAIL_FROM_NAME Carpet Broker +
   |EMAIL_FROM_ADDRESS  +
   |EMAIL_SUBJECT   +
   |EMAIL_BODY   +
   |EMAIL_AUTHENTICATION ON +
   |EMAIL_DELETE_AFTER_SEND OFF +
   |EMAIL_SHOW_DIALOG OFF

--
Carpet Broker Inc
P: 913-894-9211
F: 913-894-0138


-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Email

[Dan Goldberg]

It has nothing to do with Thunderbird as that command sends it direct.

Where is the PDF attachment saved in vattach?

Dan Goldberg

Daniel Goldberg
Mis Manager
Lance Camper




On Tue, Dec 11, 2018 at 6:44 PM -0800, "Albert Berry" 
mailto:alb...@albertberry.com>> wrote:


Check your windows settings to see if R:Base is “allowed” to access 
Thunderbird. Sometimes weird things crop up with computers.
Albert

> On Dec 11, 2018, at 3:06 PM, Carpet Broker, Dick Fey  wrote:
>
> This is NOT actually an R:base issue, but is driving us completely nuts.
>
> Many places in our R:base X application automatically sends out emails. 
> (invoice, confirmations, etc)
> We use the EMAIL ON code in the print command.  All the settings are drawn 
> from a user table.
> For years all worked fine, now 2 of our users cannot send emails, even though 
> there have been no changes
> to the R:base code, nor to the email program itself.  We all use Thunderbird 
> as our E:Mail client.
> They have no problem sending or receiving mail directly from Thunderbird.
>
> I have discussed with John Minyo tryng R:Mail, but he doesn't think that's 
> going to solve our problem.
>
> Anyone have a suggestion as to where I might look?
>
> Dick Fey
> Carpet Broker Inc.
>
> Code is below:
>
>   PRINT  +
>   WHERE refnum = .vrefnum  OPTION PDF | ORIENTATION PORTRAIT +
>   |FILENAME  +
>   |EMAIL ON +
>   |EMAIL_HOST mail.thecarpetbroker.COM +
>   |EMAIL_USERID  +
>   |EMAIL_PASSWORD  +
>   |EMAIL_TO_LIST   +
>   |EMAIL_BCC_LIST  +
>   |EMAIL_FROM_NAME Carpet Broker +
>   |EMAIL_FROM_ADDRESS  +
>   |EMAIL_SUBJECT   +
>   |EMAIL_BODY   +
>   |EMAIL_AUTHENTICATION ON +
>   |EMAIL_DELETE_AFTER_SEND OFF +
>   |EMAIL_SHOW_DIALOG OFF
>
> --
> Carpet Broker Inc
> P: 913-894-9211
> F: 913-894-0138
>
>
> --
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Email

[Albert Berry]

Check your windows settings to see if R:Base is “allowed” to access 
Thunderbird. Sometimes weird things crop up with computers. 
Albert

> On Dec 11, 2018, at 3:06 PM, Carpet Broker, Dick Fey  
> wrote:
> 
> This is NOT actually an R:base issue, but is driving us completely nuts.
> 
> Many places in our R:base X application automatically sends out emails. 
> (invoice, confirmations, etc)
> We use the EMAIL ON code in the print command.  All the settings are drawn 
> from a user table.
> For years all worked fine, now 2 of our users cannot send emails, even though 
> there have been no changes
> to the R:base code, nor to the email program itself.  We all use Thunderbird 
> as our E:Mail client.
> They have no problem sending or receiving mail directly from Thunderbird.
> 
> I have discussed with John Minyo tryng R:Mail, but he doesn't think that's 
> going to solve our problem.
> 
> Anyone have a suggestion as to where I might look?
> 
> Dick Fey
> Carpet Broker Inc.
> 
> Code is below:
> 
>   PRINT  +
>   WHERE refnum = .vrefnum  OPTION PDF | ORIENTATION PORTRAIT +
>   |FILENAME  +
>   |EMAIL ON +
>   |EMAIL_HOST mail.thecarpetbroker.COM +
>   |EMAIL_USERID  +
>   |EMAIL_PASSWORD  +
>   |EMAIL_TO_LIST   +
>   |EMAIL_BCC_LIST  +
>   |EMAIL_FROM_NAME Carpet Broker +
>   |EMAIL_FROM_ADDRESS  +
>   |EMAIL_SUBJECT   +
>   |EMAIL_BODY   +
>   |EMAIL_AUTHENTICATION ON +
>   |EMAIL_DELETE_AFTER_SEND OFF +
>   |EMAIL_SHOW_DIALOG OFF
> 
> -- 
> Carpet Broker Inc
> P: 913-894-9211
> F: 913-894-0138
> 
> 
> -- 
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Email

[Carpet Broker, Dick Fey]

This is NOT actually an R:base issue, but is driving us completely nuts.

Many places in our R:base X application automatically sends out emails. 
(invoice, confirmations, etc)
We use the EMAIL ON code in the print command.  All the settings are 
drawn from a user table.
For years all worked fine, now 2 of our users cannot send emails, even 
though there have been no changes
to the R:base code, nor to the email program itself.  We all use 
Thunderbird as our E:Mail client.

They have no problem sending or receiving mail directly from Thunderbird.

I have discussed with John Minyo tryng R:Mail, but he doesn't think 
that's going to solve our problem.


Anyone have a suggestion as to where I might look?

Dick Fey
Carpet Broker Inc.

Code is below:

  PRINT  +
  WHERE refnum = .vrefnum  OPTION PDF | ORIENTATION PORTRAIT +
  |FILENAME  +
  |EMAIL ON +
  |EMAIL_HOST mail.thecarpetbroker.COM +
  |EMAIL_USERID  +
  |EMAIL_PASSWORD  +
  |EMAIL_TO_LIST   +
  |EMAIL_BCC_LIST  +
  |EMAIL_FROM_NAME Carpet Broker +
  |EMAIL_FROM_ADDRESS  +
  |EMAIL_SUBJECT   +
  |EMAIL_BODY   +
  |EMAIL_AUTHENTICATION ON +
  |EMAIL_DELETE_AFTER_SEND OFF +
  |EMAIL_SHOW_DIALOG OFF

--
Carpet Broker Inc
P: 913-894-9211
F: 913-894-0138


--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - email printing thru gmail

[Tom Hart]

I had a similar situation, ran mine thru my website host and worked great
until they changed something and it stopped.  I tried Gmail and Yahoo and
could not get it to work.  Used my Cox account and it works fine

Tom Hart

On Aug 18, 2017 9:38 AM, "J BLAUSTEIN"  wrote:

> my client has been using the below code for the pass 10 years without any
> problem.  He recently been hack and he changed the password and now is
> working thru gmail.
>
> I would appreciate some assistance in changing the code to permit the
> email to go out via the gmail client.
>
> thanks
>
> J
>
>
> PRINT A9_CONTRACT WHERE EIDEN = .VEIDENFM  +
> OPTION PDF|FILENAME WELCOME.PDF |EMAIL ON  |EMAIL_TO_LIST
>  +
>* |EMAIL_HOST smtpout.secureserver.net
>  *|EMAIL_BCC_LIST em...@visualimageny.com
> +
> |EMAIL_REPLY off...@visualimageny.com +
> *|EMAIL_USERID off...@visualimageny.com
>  |EMAIL_PASSWORD  +*
> |EMAIL_FROM_NAME VISUAL IMAGE OFFICE |EMAIL_FROM_ADDRESS
> off...@visualimageny.com +
> |EMAIL_SUBJECT  |EMAIL_BODY 
> |EMAIL_DELETE_AFTER_SEND Off +
>* |EMAIL_AUTHENTICATION on |EMAIL_PORT 3535* |EMAIL_SHOW_DIALOG On
> --
>
> *J. Blaustein*
>
> *J Blaustein Associates, Inc.*
>
> *12 Herrick Drive*
>
> *Lawrence, NY 11559*
>
> *516-371-3445 <(516)%20371-3445> FAX 516-515-4549 <(516)%20515-4549>*
>
> --
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - email printing thru gmail

[A. Razzak Memon]

Use R:MailX to accomplish your R:BASE task more securely and professionally!

R:MailX has an easy to use configuration GUI for setting up specific 
server settings, which allows SMTP authentication.


R:Mail supports encrypted mail through Secure Sockets Layer (SSL 
v2/v3) and Transport Layer Security (TLS v1).


http://www.rbase.com/products/rmail/intro.php

Very Best R:egards,

Razzak


At 11:27 AM 8/18/2017, Dan Goldberg wrote:

Unfortunately the print to email command does not support SSL. Gmail 
requires SSL to send email.


It is on my wish list..

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On 
Behalf Of J BLAUSTEIN

Sent: Friday, August 18, 2017 7:38 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - email printing thru gmail

my client has been using the below code for the pass 10 years 
without any problem.  He recently

been hack and he changed the password and now is working thru gmail.

I would appreciate some assistance in changing the code to permit 
the email to go out via the

gmail client.


--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - email printing thru gmail

[Dan Goldberg]

Unfortunately the print to email command does not support SSL. Gmail requires 
SSL to send email.


It is on my wish list..

Dan Goldberg





From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of J 
BLAUSTEIN
Sent: Friday, August 18, 2017 7:38 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - email printing thru gmail


my client has been using the below code for the pass 10 years without any 
problem.  He recently been hack and he changed the password and now is working 
thru gmail.

I would appreciate some assistance in changing the code to permit the email to 
go out via the gmail client.

thanks

J



PRINT A9_CONTRACT WHERE EIDEN = .VEIDENFM  +
OPTION PDF|FILENAME WELCOME.PDF |EMAIL ON  |EMAIL_TO_LIST  +
|EMAIL_HOST smtpout.secureserver.net |EMAIL_BCC_LIST 
em...@visualimageny.com<mailto:em...@visualimageny.com> +
|EMAIL_REPLY off...@visualimageny.com<mailto:off...@visualimageny.com> +
|EMAIL_USERID off...@visualimageny.com<mailto:off...@visualimageny.com> 
|EMAIL_PASSWORD  +
|EMAIL_FROM_NAME VISUAL IMAGE OFFICE |EMAIL_FROM_ADDRESS 
off...@visualimageny.com<mailto:off...@visualimageny.com> +
|EMAIL_SUBJECT  |EMAIL_BODY  |EMAIL_DELETE_AFTER_SEND 
Off +
|EMAIL_AUTHENTICATION on |EMAIL_PORT 3535 |EMAIL_SHOW_DIALOG On
--

J. Blaustein
J Blaustein Associates, Inc.
12 Herrick Drive
Lawrence, NY 11559
516-371-3445 FAX 516-515-4549
--
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - email printing thru gmail

[J BLAUSTEIN]

my client has been using the below code for the pass 10 years without 
any problem.  He recently been hack and he changed the password and now 
is working thru gmail.


I would appreciate some assistance in changing the code to permit the 
email to go out via the gmail client.


thanks

J


PRINT A9_CONTRACT WHERE EIDEN = .VEIDENFM  +
    OPTION PDF|FILENAME WELCOME.PDF |EMAIL ON  |EMAIL_TO_LIST 
 +
*|EMAIL_HOST smtpout.secureserver.net *|EMAIL_BCC_LIST 
em...@visualimageny.com +

    |EMAIL_REPLY off...@visualimageny.com +
*    |EMAIL_USERID off...@visualimageny.com |EMAIL_PASSWORD  +*
    |EMAIL_FROM_NAME VISUAL IMAGE OFFICE |EMAIL_FROM_ADDRESS 
off...@visualimageny.com +
    |EMAIL_SUBJECT  |EMAIL_BODY  
|EMAIL_DELETE_AFTER_SEND Off +

*|EMAIL_AUTHENTICATION on |EMAIL_PORT 3535* |EMAIL_SHOW_DIALOG On

--

*J. Blaustein*

*J Blaustein Associates, Inc.*

*12 Herrick Drive*

*Lawrence, NY 11559*

*516-371-3445 FAX 516-515-4549*

--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Email

[Dan Goldberg]

Sometimes they require ssl which this command doesn’t support. If you turn off 
ssl requirement in gmail you should get it to work.

[cid:image003.jpg@01D1EEF5.3CA94720]

Dan

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Tom Hart
Sent: Friday, August 5, 2016 8:27 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Email

I may be with my website hose, but I have tried thru my gmail account and I can 
get it to connect under email settings in Rbase but I still can't get it to 
send.

Tom

On Fri, Aug 5, 2016 at 10:17 AM, Dan Goldberg 
<d...@lancecamper.com<mailto:d...@lancecamper.com>> wrote:
I would try to break it down to see what is broken. Maybe try the print command 
without the email, then remove email_attachments option.

Dan

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>] On Behalf Of 
Tom Hart
Sent: Thursday, August 4, 2016 4:59 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - Email

I have used the email on report settings to send emails directly thru my 
website and it has worked fine.  Now it has stopped and when I test I get no 
connection.  I have checked with my webhost and am doing everything write. The 
following is my code which worked until recently

PRINT stemailreport WHERE COUNT = 1 OPTION PDF|FILENAME dbcheck.CHK +
  |EMAIL ON +
  |EMAIL_HOST mail.worldsecureemail.com<http://mail.worldsecureemail.com> +
  |EMAIL_USERID t...@mywebsite.com<mailto:t...@mywebsite.com> +
  |EMAIL_PASSWORD Mycorrectpassword +
  |EMAIL_TO_LIST tooma...@sbcglobal.net<mailto:tooma...@sbcglobal.net> +
  |EMAIL_FROM_NAME Daisy Exchange +
  |EMAIL_FROM_ADDRESS t...@daisyexchange.com<mailto:t...@daisyexchange.com> +
  |EMAIL_SUBJECT hello +
  |EMAIL_BODY FROM Daisy Exchange +
  |EMAIL_ATTACHMENTS dbcheck.CHK +
  |EMAIL_PORT 587 +
  |EMAIL_AUTHENTICATION ON +
  |EMAIL_DELETE_AFTER_SEND ON +
  |EMAIL_SHOW_DIALOG On
  return

Tom Hart
--
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Email

[Tom Hart]

I may be with my website hose, but I have tried thru my gmail account and I
can get it to connect under email settings in Rbase but I still can't get
it to send.

Tom

On Fri, Aug 5, 2016 at 10:17 AM, Dan Goldberg <d...@lancecamper.com> wrote:

> I would try to break it down to see what is broken. Maybe try the print
> command without the email, then remove email_attachments option.
>
>
>
> Dan
>
>
>
> *From:* rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] *On
> Behalf Of *Tom Hart
> *Sent:* Thursday, August 4, 2016 4:59 PM
> *To:* rbase-l@googlegroups.com
> *Subject:* [RBASE-L] - Email
>
>
>
> I have used the email on report settings to send emails directly thru my
> website and it has worked fine.  Now it has stopped and when I test I get
> no connection.  I have checked with my webhost and am doing everything
> write. The following is my code which worked until recently
>
>
>
> PRINT stemailreport WHERE COUNT = 1 OPTION PDF|FILENAME dbcheck.CHK +
>
>   |EMAIL ON +
>
>   |EMAIL_HOST mail.worldsecureemail.com +
>
>   |EMAIL_USERID t...@mywebsite.com +
>
>   |EMAIL_PASSWORD Mycorrectpassword +
>
>   |EMAIL_TO_LIST tooma...@sbcglobal.net +
>
>   |EMAIL_FROM_NAME Daisy Exchange +
>
>   |EMAIL_FROM_ADDRESS t...@daisyexchange.com +
>
>   |EMAIL_SUBJECT hello +
>
>   |EMAIL_BODY FROM Daisy Exchange +
>
>   |EMAIL_ATTACHMENTS dbcheck.CHK +
>
>   |EMAIL_PORT 587 +
>
>   |EMAIL_AUTHENTICATION ON +
>
>   |EMAIL_DELETE_AFTER_SEND ON +
>
>   |EMAIL_SHOW_DIALOG On
>
>   return
>
>
>
> Tom Hart
>
> --
> 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 rbase-l+unsubscr...@googlegroups.com.
> 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 rbase-l+unsubscr...@googlegroups.com.
> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.