You will be happy after you get the email server settings done. We send well
over a hundred pdfs(order/shipment confirmations, po requests, invoices)
with the print command everyday automatically.
Here is one my print commands that I use:
SET VAR veuser = ((cval('netuser')) + '@lancecamper.com')
set var veSalesFaxEmail = dlremail in dealer where dlrnum = .vdlrnum
PRINT unitconfirm ORDER BY optcode +
WHERE serial = .vserial AND quantity <> 0 +
AND descript NOT LIKE '%(int use)' OPTION PDF| +
FILENAME c:\confaxes\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.mymailserver.net |SHOW_CANCEL_DIALOG +
OFF |USE_COMPRESSION ON |COMPRESSION_METHOD MAXCOMPRESS | +
EMBED_USED_FONTS OFF
Dan
-----Original Message-----
From: Jim Belisle
Sent: Wednesday, September 12, 2012 8:49 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: email snd window
Dan,
I have tried that in the past and never got it to work.
I will have to get with our outsourced IT person and find out the settings.
It may be that we have to have authentication.
Thanks for the input.
Jim
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg
Sent: Wednesday, September 12, 2012 10:08 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: email snd window
I would skip outlook and mapimail to send out the pdfs and let rbase print
command send them out. It works pretty good.
You can pull the sender/receiver name from the database and even have a
prompt for a message.
>From the help file(you can add or delete options to your preferences):
PRINT Invoice WHERE TransID = 1031 +
OPTION PDF|FILENAME Invoice_1031.PDF +
|EMAIL ON +
|EMAIL_TO_LIST [email protected], [email protected] +
|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_DELETE_AFTER_SEND ON +
|EMAIL_SHOW_DIALOG OFF
Dan Goldberg
From: Jim Belisle
Sent: Wednesday, September 12, 2012 7:49 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: email snd window
Tom,
We use the Mapimail plugins and when I used that code it gave me an error
message.
I used it as the last line of the code.
Maybe I should set that as a variable.
And use the variable within the parameters.
That may do it.
From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART
Sent: Wednesday, September 12, 2012 8:58 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: email snd window
In the email setup do this
|EMAIL_SHOW_DIALOG off
Tom Hart
From: Dan Goldberg <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tue, September 11, 2012 11:07:53 PM
Subject: [RBASE-L] - RE: email snd window
check out the option PDF when you print the report. You can have the report
cc the person who is sending it. That way they get a copy in their outlook.
Dan
From: Jim Belisle
Sent: 9/11/2012 4:43 PM
To: [email protected] (RBASE-L Mailing List)
Subject: [RBASE-L] - email snd window
Someone covered this a while back but I cannot find the thread on it.
I want to automatically email our shipment verifications.
The verifications are sent as PDF attachments.
We use outlook.
For every email, we have the email box come up that makes us hit ‘send’.
Is there code to prevent this from coming up each time?
Still in 7.6
Jim
