Hi Luke,

Try this.

Macro record the whole process like you will do so manually. Then edit the recorded actions acoordingly.

Alternatively, you can automate the process with "mouse" and "send keystrokes" actions.

See if this works for you. If you have any issue with any parts of the process, you can write it out in detail here. And we can look at it for you.

Thanks!

Jag

Jag

I looked at doing it via macro recording, but came on 2 obstacles:

The print dialog is different for Excel and Email files. (OK, perhaps I could use some sort of conditional here?). That's not really the biggest issues though. The main issue for me was: How can I define the files in a folder for the purpose of opening each one?

thanks,

Luke

Alloha Luke! Since most of the files are emails (I'm assuming .eml or sth), you can use the "Get Files in Folder" action, set a specific filter to grab only the emails in the properties window of the action (i.e. *.eml), and record the procedure for one email. Then you should use a "For Each" action to repeat the process for every email file in the list.

I hope that this is clear enough.

Codex, thanks for the help. I was missing just one piece of information: How do I open the email files? I didn't see any "Open File" method in the lists (I looked under the Files group).

I probably wasn't very clear but I couldn't see how "Get Files In Folders" could be followed by an Open File command.

-----

I've just  looked again. Now I see I use "Open Application" and just pass a file name. I just tested it and it worked. The name of that method confused me!

I can see the whole skeleton of this automation now.

Luke

Hi Luke,

The "Get File From Folders" is very useful. Other actions like "Read from Text" and "Read from Excel" are extremely handy because you can put in data inside which you can iterate using "For Each" loop action.

The "Open Application" can be used for many other applications like browsers, softwares and other 3rd party tools.

Overall, I'm glad it has worked for you.

Jag

One very small addition: the "Run Application" action is practically equivalent to double clicking to a specific file. So, if you place the path to an executable in the "Application Path:" field, it will run the executable. On the other hand, if you place a path to a specific file (e.g. a .pdf file) it will automatically use the default program to open the specific file (e.g. Adobe Reader), just like if you were double clicking on the pdf file.

CHEERS!