Using a View for a Datasource in a Word macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cathy - 04 Apr 2007 22:26 GMT

I am printing different templates out for a mailing and have had to switch
from Access to a PSQL View. The template works fine as long as the view is
populated, but if it is empty, then the macro stops. I am trying to find
some code to put in the macro so that I can query the View to see if it's
empty. If it is, then the code will go to the next template. Any thoughts
on if this can be done? I am doing all of this through a Word document that
has a command button to activate the macro. I am using Word 2002.

Signature

cathy

Reply to this Message

Doug Robbins - Word MVP - 05 Apr 2007 19:04 GMT

Show us the code that you are using.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am printing different templates out for a mailing and have had to switch
> from Access to a PSQL View. The template works fine as long as the view
[quoted text clipped - 6 lines]
> that
> has a command button to activate the macro. I am using Word 2002.

Reply to this Message

Rate this thread: