Combine Outlook Attachments Into One PDF

Hi, thedeal56.

The answer to that question depends on what software you have available for combining the pictures and whether it can be automated.  It's definitely possible to write a macro to do something like this assuming that you have suitable software and that software supports automation.  I've never had the need to do anything like this, so I've no idea what software you'd use to accomplish combining the pictures.

Are you talking about acrobat?  That's what I'm using to combine multiple photos into one pdf.  

Since you're using Acrobat, that's the tool I'm talking about.  I'm not an Acrobat expert and don't know of a way to script creating a PDF from a series of pictures.  I can handle the Outlook portion of this, saving the pictures to disk and calling some process that combines the pictures into a PDF.  It's that other process that I'll need help with.  If you know of a script or batch process that does this, then I can help.  Otherwise, the best I can do is save the pictures to disk.

So, you're saying that you can help with the part of the macro that saves the pics to a folder, but not with the part that converts them into a single pdf file?  It sounds like I may be looking at running two batch processes.  One to move the files out of outlook, and one to combine the files.  Is that right?  I was hoping to settle this all with one outlook macro, so if it can't be done that way, can you show me how to do the following?:

What I need the macro to do:

1.  Create a folder which has the name of the subject of the email
2.  Save all attached pictures to the newly created folder.

Thanks for helping me with this.

"you can help with the part of the macro that saves the pics to a folder"
Definitely.

"not with the part that converts them into a single pdf file"
Not without some guidance.  Combining the pictures into a single PDF file doesn't have anything to do with Outlook.  I'll be glad to help with that if you know how to automate the process.  For example, if you know this can be done with a command-line command and you know what the command is, then I can right a script that will save the files and run that command.  But, if you're as much in the dark as I am about how to perform that step outside of the GUI, then I can't help.

"One to move the files out of outlook, and one to combine the files."
It doesn't have to be if you know what the batch process for combining the files and producing a PDF is.  Saving the files is an Outlook process, combining them and producing a PDF isn't.  

How do you want to run the macro?  Do you want to select the messages and then run it?

I'm going to check around on the possible command line pdf combine.  I would like to avoid selecting all the files in the email.  If it's possible, can the macro assume that the open email's attachments are the ones I want to save to the folder?

Yes, that's possible.  I'll hold up on this until I hear back from you on the pdf aspect.

I think I have a solution for the pdfs.  It's probably not the best way, but let me know what you think.  There is a program called OmniFormat that monitors a folder's contents, and attempts to convert anything in the folder into a pdf.  This process will happen on its own; I'll just need to set the monitored folder to whichever directory the files are initially saved to.  Once the files are in the folder (Let's use C:\PDF), we can use PDF Tool Kit (PDFTK) to do the actual combining.  

Here's a command line example of the combine:

--> pdftk c:\pdf\1.pdf c:\pdf\2.pdf c:\pdf\3.pdf cat output c:\[NAME OF EMAIL SUBJECT]\123.pdf

So, here's how I'm guessing the macro needs to work.

1. Delete all files in C:\PDF
2. Copy the open email's files to C:\PDF
3. Make a directory similar to this: C:\CombinePDF\[NAME OF EMAIL SUBJECT]
4. Run the combine command: pdftk c:\pdf\1.pdf c:\pdf\2.pdf c:\pdf\3.pdf cat output C:\CombinePDF\[NAME OF EMAIL SUBJECT]\123.pdf

The only problem I can foresee is the possibility of the combine taking place before all the images are converted to .pdf.  If it's not too much trouble, maybe adding some type of delay between steps 3. and 4. would come in handy.  I'll have to do some testing to see how long the conversions actually take, so I could adjust the delay as needed.  Thanks again.  

Hey, that works great.  Thanks for all your help.

You're welcome.