Determine printer or email from file
We have a script to pull an email address based on a user profile. But, I need to be able to print several hundred documents to different email addresses based on a file name or other parameter. For example, one Excel macro will update data and send an email to 200 different people. I would like to use print distributor to convert the file to pdf, then mail to the end user. Each sheet will be different. Can this be done? Today, I am converting the sheet to PDF in the macro and it is very slow.
3rd Nov 2008
Chris,
We can't read the content of the file however if you can change the document name then we could use that.
Alternatively perhaps you can write out a text file with the destination before you print the document?
4th Nov 2008
This thread is closed to new posts.
