Using the information at The Access Web I was able to finally get the report to print out as pdf without having to install anything that doesn't already exist on all the computers in our network. However when using the code I am prompted with a box to select the destination and name the file. Is there a way to set that in the code so that I can bypass this box? And also can I supress Adobe previewing the file after printing it?
The emailing of the file is supposed to be seamless. I wish to save the file to a temporary directory, then mail it. After mailing it I will kill the directory and the file.
All help is appreciated!