×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Sending a number of PDF's (in a report or other approach)

Sending a number of PDF's (in a report or other approach)

Sending a number of PDF's (in a report or other approach)

(OP)
Hello All,

I have an invoice table tbl_Invoice which has the following:

Inv_Id (unique ID)
Inv_Name (a client’s name)
Inv_Path (the file path of the scanned PDF invoice)

The table will contain a number of invoices for each client.

I would like to be able to send the client a single email attaching the invoices.

The email part of it I can do fine, it’s just trying to get the pdf in a single file.

At present I send a single email with single invoice attached - this works OK, but when clients maybe have 30 or so invoices scans it means them getting 30 or so emails.

To be clear, the invoices are ones that have been paid via our company for the client so they are stored as individual scans.

I was hoping to create a report which would display each PDF, but as far as I can see there is no way to do this (the web viewer control will only work on a single form).

Can anyone give some advice - or a different approach?

Many thanks Mark












RE: Sending a number of PDF's (in a report or other approach)

Options...

1) Attach multiple files to the e-mails
2) Merge the PDF files then e-mail them
3) Make a zip archive of the files

You are claiming number 2 is right. We each have adobe pro so we can automate it and use it to merge documents via the API. This should be easy code to find but at the same time Adobe Pro seats are not cheap.

I have used an open source Print to PDF program that allows you to collect, merge and finalize your prints... It is called PDF Creator. You'd have to set registry keys to put it in collect mode, change it back to finalize the last file and print each pdf to that soft printer (probably set the default printer). I also think there are command line tools that you could use to merge the files but I don't know any off the top of my head or if there are free ones.

You can zip files with VBA using Windows... I remember it gave me some trouble to figure it out, alas I don't have that code now.

RE: Sending a number of PDF's (in a report or other approach)

Quote:

I don't know any off the top of my head or if there are free ones.

Regarding the PDF portion. PDFtkServer https://www.pdflabs.com/tools/pdftk-server/ is a free command line tool for merging, splitting, bookmarking, etc. pdf files. It does not require changing settings to default printers and it doesn't need Acrobat. Simply run it in vba code using shell command. If you need code example, I could provide a sample.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close