At 02:53 PM 11/9/2005, Duane Heffelfinger wrote:
Can I:
1. Get the password from an end user using a dialog
box
2. Set up the email settings in the background and
run the test button
(that displays on the "Report E-mail Settings")
3. Get a result to know if the test button worked
or failed
Duey,
You can totally automate the entire process using the
following PRINT command:
Here's how: (exclusive feature of RBG75 and V-8 Turbo)
Example:
-- start
CONNECT RRBYW10
-- Verify the existence of PDF Sub-Directory
SET VAR vChkFile = (CHKFILE('PDF'))
IF vChkFile <> 1 THEN
MD PDF
ENDIF
PRINT SalesSumAndSubTot +
OPTION PDF +
|AUTHOR Accounting Team of ConComp +
|BACKGROUND_COLOR WHITE +
|BACKGROUND_FILE NONE +
|BACKGROUND_TYPE CENTER +
|COMPRESSION_METHOD MAXCOMPRESS +
|DURATION 0 +
|EMBED_USED_FONTS ON +
|ENCRYPT_FILE ON +
|ENCRYPTION_LEVEL 128BIT +
|FILENAME PDF\SalesSumAndSubTotals.PDF +
|FONT_ENCODING WIN_ANSI +
|GENERATE_TOC ON +
|IMAGE_DPI -1 +
|IMAGE_FORMAT JPG +
|INCLUDE_HYPERLINKS ON +
|INCLUDE_IMAGES ON +
|INCLUDE_LINES ON +
|INCLUDE_RICHTEXT ON +
|INCLUDE_SHAPES ON +
|JPEG_QUALITY 100 +
|KEYWORDS SubTotals Totals Sales Summary +
|OPEN ON +
|OWNER_PASSWORD RRBYW10Owner +
|ENABLE_PRINTING OFF +
|ENABLE_COPYING OFF +
|ENABLE_MODIFYING OFF +
|PIXELFORMAT 32 +
|PRESENTATION_MODE NONE +
|RICHTEXT_ENCODING_TYPE PLAINTEXT +
|SHOW_CANCEL_DIALOG ON +
|SUBJECT Sales Summary Report +
|TITLE Customer Sales Sub-Totals and Totals +
|USE_COMPRESSION ON +
|USER_PASSWORD RRBYW10 +
|PAGE_LAYOUT_SINGLE_PAGE +
|PAGE_MODE NONE +
|HIDE_TOOLBAR OFF +
|HIDE_MENUBAR OFF +
|HIDE_WINDOW_UI OFF +
|FIT_WINDOW OFF +
|CENTER_WINDOW OFF +
|NON_FULL_SCREEN_PAGE_MODE NONE +
|EMAIL_HOST mail.yourmailserver.com +
|EMAIL_USERID johndoe +
|EMAIL_PASSWORD your_smtp_password +
|EMAIL_BODY Please see attached PDF document! +
|EMAIL_FROM_ADDRESS [EMAIL PROTECTED] +
|EMAIL_FROM_NAME John G. Doe +
|EMAIL_TO_LIST [EMAIL PROTECTED] +
|EMAIL_SUBJECT Sales Summary Report +
|EMAIL_PORT 25 +
|EMAIL_AUTHENTICATION ON +
|EMAIL_DELETE_AFTER_SEND ON +
|EMAIL_SHOW_DIALOG ON
RETURN
-- end
Any of the parameters used in this example may by
replaced with pre-defined &ersand variable(s).
That's all there is to it!
Enjoy and make sure to have fun.
Very Best R:egards,
Razzak.
