3000AD Knowledge Base
Home » Categories » Knowledge Base Home » PDF-eXPLODE » Processing

How do I print documents that have no e-mail address?

ISSUE:

Some of the Clients may not have email addresses. So processing a whole batch of invoices where only some of them have email addresses, need not be a processing problem. Where an Invoice has no email address, it is necessary to Print and mail the invoice to the client via the post. How do you achieve a solution that suits email and print?  


ANSWER:

If the Database has no email address for the Client and you want to print those invoices, then the following technique will produce a single file containing all documents to be printed. (If you want each document to be in a separate exploded PDF, use a Variable for the file name).

Create a Default Message ID called Print1 – not PRINT as this is a “reserved “ word in Windows. For this Print1 , check the  Print check box and select PRINT ONLY and nominate a printer. Now allocate a folder where the exploded PDF for Print Only will be saved and you can (optionally) give this exploded file a name here. Now click APPLY. 

In your Crystal Reports (it will be somewhat similar in MS Access report writer) write a formula with If Then Else logic –something like this:

If Trim({email_addr}) <> “” Then
     "<pdfexplode>"+{email_addr}+"</pdfexplode>"
Else 
    "<pdfexplode>Print1#</pdfexplode>"


To test, make the tag visible and run the report as a preview to the screen and check where the pages have no email address and verify that the Print tag actually looks like this:

     <pdfexplode>Print1#</pdfexplode>

If OK, make the tag invisible and run the Print and verify that PDFs go to the printer

Alternatively, you could have a non-email tag (like PRINT_THESE) to replace the defined Message ID "Print1" without the need to define it. This is a non-email tag cannot be emailed, but will still create an exploded PDF. This Exploded PDF can be printed by manually  opening it at the end of the process run.This is the formula to create a a non-email tag:

If Trim({email_addr}) <> “” Then
     "<pdfexplode>"+{email_addr}+"</pdfexplode>"
Else
     "<pdfexplode>PRINT_THESE</pdfexplode>"

A “PRINT_THESEyymmdd_hhmm.PDF” or “PRINT_THESE_yymmdd_hhmm.PDF” will be created in the default Mail exploding folder and if NO suppression of Date/Time on the filename. Then open this PDF and file/print later.

Comments Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Security Code Security Code
Related Articles
How can I clear the print jobs queue and restart PDF-eXPLODE as it appears frozen?
Viewed 1984 times since Sat, Oct 1, 2016
How can I debug any processing issues?
Viewed 2063 times since Fri, Dec 5, 2014
I cannot figure out why my exploded document won’t email
Viewed 1691 times since Fri, Dec 5, 2014
Why is my PDF not encrypted with the password I saved in the Tag?
Viewed 1595 times since Fri, Dec 5, 2014
Which characters cannot be used in the PDF-eXPLODE tag?
Viewed 1698 times since Fri, Dec 5, 2014
Error: System cannot find the file specified
Viewed 3545 times since Fri, Dec 5, 2014
I am getting a "Run time error 70 - permission denied"
Viewed 6567 times since Fri, Dec 5, 2014
I can’t get PDF drag and drop to work when I drop a tagged PDF onto the PDF-eXPLODE Print Queue window
Viewed 3754 times since Fri, Dec 5, 2014
How can you create a Tag that can Fax, Email and/or Print within the same process?
Viewed 2055 times since Fri, Dec 5, 2014
Error: 75 Path/File access error
Viewed 2365 times since Wed, Nov 26, 2014

Subscribe to Knowledge Base

Get notified when new articles are added to the knowledge base.