Mailing labels template with MailMerge automation and SQL VIEW

A

ALPHA DAVIS

Hi,
I've created a Word template of mailing labels and the data source is a
SQL2000 view. It's working just fine when I click on the Merge icon on the
menu. I want the template to automatically merge the data source and crate
the labels when I double click on the file (not open to edit the template),
which creates a new document based on this template, without having to click
on the Merge icon on the menu. I added the following VBA code but it is
still not merging automatically. I appreciate some suggestion or help on
how to make this work.
p.s., what is a Main Document definition? I think the State condition below
is verifying for a Main documetn.

Private Sub Document_New()
If ActiveDocument.MailMerge.State = wdMainAndDataSource Then
ActiveDocument.MailMerge.Execute
End Sub
 
C

Cindy M -WordMVP-

Replied to duplicate question posted in one of the word.vba
newsgroups.

Cindy Meister
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A way to mail merge from excel into a word label template? 0
Cannot get field values 6
"Opening this document will run the following SQL command" prompt problem 4
Automate opening a merge with Mailmerge Recipients open 5
Using a Downloaded Template in Mail Merge 1
Mail Merge Functionality 0
mailmerge label Problem 2
Is it possible to create a mail merge with unformatted text links to mergefield? 1

Top