Mail Merge problems
 

Hi,

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

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



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 xl
document (data source) on launch, and as it is already open this the
results in it offering a read only version and means that potentiall
the user is left with multiple open copies of the xls doc.

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

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

Thank

--
Alec
-----------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...fo&userid=3104
View this thread: http://www.excelforum.com/showthread.php?threadid=51816