Thanks for both suggestions. I will look at the suggestions. Each page looks at a different Query, and each query is pushing the limit of too many fields. So I don't think I can make 3 pages into one document and then run them through the vba merge process. That would be the most ideal solution.
This is a production system used in many offices, and users have different versions of Office. So it needs to be kept as simple as possible. I see products generally using .pdf that seem to make it very easy and seamless. I really need one simple solution for all versions of Office. Just asking for the moon! I would have thought it could be done in vba code, but I don't know where to begin. Thanks again.
|