--Setup email host **Below is where I have a table with the variour email protocol** select StEmailHost,StEmailUserID,StEmailPassword,StEmailPort,StEmailSubject,StEmailBody+
into zStEmailHost,zStEmailUserID,zStEmailPassword,zStEmailPort,zStEmailSubject,zStEmailBody+ from StEmailTable where count = 1 select FORMAT(emailaddress,'???????????????????????????????????????????????????????????')+ into zEmailAddress from ConsignerTab where ConsignNum = .vConNum set var zStEmailBody text = ' ' print StEmailReport where count = 1 option pdf|filename Stemail.pdf + |EMAIL ON + |email_host &zStEmailHost + |email_userid &zStEmailUserID + |email_password &zStEmailPassword + |EMAIL_TO_LIST &zEmailAddress + |EMAIL_FROM_NAME Daisy Exchange + |EMAIL_FROM_ADDRESS &zStEmailUserID + |EMAIL_SUBJECT &zStEmailSubject + |EMAIL_BODY &zStEmailBody + |email_port &zStEmailPort + |email_authentication on + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG on clear var zStEmailHost,zStEmailUserID,zStEmailPassword,zStEmailPort,zStEmailSubject,zStEmailBody RETURN ________________________________ From: Jim Belisle <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, January 11, 2012 9:08:25 AM Subject: [RBASE-L] - Re: continued email problem Tom, I would have no idea how to accomplish what you suggested. I am very lacking in this area. James Belisle Making Information Systems People Friendly Since 1990 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Wednesday, January 11, 2012 9:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: continued email problem I go thru my mail server on my website and created a table with all the protocol, which I set to variables and print write from reports. Tom Hart ________________________________ From: Mike Byerley <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, January 11, 2012 8:52:24 AM Subject: [RBASE-L] - Re: continued email problem RBTI has a fix in the latest MAPI mail plugin that addresses the outlook security warning issue. ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, January 11, 2012 9:36 AM Subject: [RBASE-L] - Re: continued email problem Karen, The file is always sent. That is not a problem. Outlook freezes up with a message stating something like: "Another program is trying to access Outlook." The screen then will not allow me to access any part of Outlook until I exit then restart Outlook. I added the SET VAR vEmresult = (DLFree('mapimail4.rbl')) to the end of the code at someone's suggestion a while back hoping that would care for the problem. I thought it did but the problem has continued. I noticed in some of the questions about email they use this type of code: PRINT Invoice WHERE TransID = 1031 + OPTION PDF|FILENAME Invoice_1031.PDF + |EMAIL ON + |EMAIL_TO_LIST [email protected], [email protected] + Can these be defined variables as well? |EMAIL_FROM_NAME John D. Johnson + |EMAIL_FROM_ADDRESS [email protected] + |EMAIL_SUBJECT Imagine The Possibilities! + |EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! + |EMAIL_ATTACHMENTS C:\Letters\otherstuff.pdf#C:\Letters\morestuff.pdf + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG OFF RETURN What is the difference between using variables and using the above code? I am so lacking in how email programs work. James Belisle Making Information Systems People Friendly Since 1990 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, January 11, 2012 8:06 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: continued email problem James: I suppose the first thing I would do is to put a pause statement after the creation of the PDF file. Perhaps the PDF file has not yet been fully formed before RBase gets to the line where you're trying to send out the file. Maybe put a "pause for 5" in there. Karen In a message dated 1/11/2012 7:43:26 AM Central Standard Time, [email protected] writes: I have read many threads form the past on emails but still cannot figure why Outlook or RBASE lock up. The only difference seems to be we create the PDF just before sending it. This has been a thorn in my flesh for some time and I would like to get it fixed. Any suggestions sure would be appreciated.
