Hi,

I have a worksheet containing names and addresses and I need to print labels for this list.

I am linking across to Word Mail Merge with the following code


 
Sub labelprint() 
    Dim objWord As Object 
     ' Start app
    Set objWord = CreateObject("Word.application") 
     ' Open doc
    objWord.Documents.Open Filename:="\\Svr1\lampandgear\users\Alec\Pipeline\Address Labels.doc" 
    objWord.Visible = True 
     ' Print doc
    objWord.Application.PrintOut 
     ' close & save doc
    objWord.ActiveDocument.Close savechanges:=True 
    Set objWord = Nothing 
End Sub
Unfortunately I have 2 problems with it....

1. The Word doc tries to re-launch the mail merge associated xls document (data source) on launch, and as it is already open this then results in it offering a read only version and means that potentially the user is left with multiple open copies of the xls doc.

2. The Word document doesnt appear to "run" the merge prior to printing (even though it has opened and referenced the data source).

I know that these are probably Word questions but has anyone come up against them before and know any solutions?

Thanks