Is it Possible for Access to retreive Publisher Files?

[Manc]

Hi there.

We have envelopes set out in Publisher for each of our Clients. All we do is go to the envelope folder, select the envelope we want, the file opens in Publisher, we select print, close the file and the envelope prints out on the dedicated envelope printer(!).

Is there a way that within Access, when a user accesses a customer record there is a button or link that they can click on and the relevant Publisher envelope is then printed, ideally without Publisher opening in view.

Alternatively, if anyone can think of a more practical solution, please share your wisdom.

Your time is appreciated.
Manc

 

[HiTechCoach]

Welcome to AWF!

Yes, it is possible to use a command line to print a Publisher file. What you described sounds like a lot of extra work that can easily be eliminated.

For printing envelopes I normally use:

1) An Access report. (think of it just like a merge)

or

2) using Automation to run a Word Merge or a Publisher merge

Note: You can perform a "mail merge" with Publisher.

I would avoid creating a separate file for each client.I see no need for this when it can be handled dynamically.