The print to pdf command sends direct and does not use outlook to send. I think the problem is you have to state the EMAIL_HOST in your print command. It needs to know what email server you want to send thru. Some email servers require authentication and some don't.
I use this extensive at my place with variables. I use the & instead of the . in the option portion of the command. My server uses the print pdf to email and they do not have any email program installed. Here is a sample: PRINT unitconfirm ORDER BY optcode + WHERE serial = .vserial AND quantity <> 0 + AND descript NOT LIKE '%(int use)' OPTION PDF| + FILENAME c:\Unit_Conf.PDF |EMAIL + ON |EMAIL_TO_LIST &veSalesFaxEmail |EMAIL_FROM_NAME Lance Sales | + EMAIL_FROM_ADDRESS &veuser | EMAIL_SUBJECT Lance Unit Confirmation | + EMAIL_BCC_LIST &veuser |EMAIL_BODY Attached are your unit + confirmation(S). | EMAIL_DELETE_AFTER_SEND ON |EMAIL_SHOW_DIALOG + OFF |EMAIL_HOST mail.myservername.net |SHOW_CANCEL_DIALOG + OFF |USE_COMPRESSION ON |COMPRESSION_METHOD MAXCOMPRESS | + EMBED_USED_FONTS OFF Dan Goldberg -----Original Message----- From: Jim Belisle Sent: Wednesday, January 11, 2012 7:08 AM To: RBASE-L Mailing List 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.
