Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problems using Excel as a mail merge database in Office XP | Excel Worksheet Functions | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
mail merge problems | Setting up and Configuration of Excel | |||
MAIL MERGE PROBLEMS | Excel Discussion (Misc queries) | |||
Real problems automating a mail merge | Excel Programming |