Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
"Peter Jamieson" wrote in message
... : If I open the template (rather than creating a new doc based on the : template) I am prompted with the SQL prompt. : : OK, in that case I suggest you open the template, go through your connection : process, then click the first button, select the "Normal Word Document" : option, and save the template. At least that should stop the /template/ from : trying to connect when it loads. This works beautifully. When I first started messing around with this I thought for a little while that I could just keep changing the data in the data source (it's a short row of data) and then every time I opened the template the data would already be there. This seemed like a very cool option. However, the side effect of that was that the documents I saved from the templates still kept the data connection, which was no good. : : OK, the key statement is this one - I'll just chop out stuff I'm pretty sure : is not needed for starters: : : ActiveDocument.MailMerge.OpenDataSource _ : Name:="K:\AA documents\SRC IP Tracking spreadsheet.xls", _ : Connection:="CurrentData", _ : SQLStatement:="" : : The main questions are : a. does this need to work in Word 2000 as well as Word 2003 - if so, is it : easy for you to maintain two different versions? Or does it just need to : work in Word 2003? : b. are you connecting to a named range called CurrentData? Is it in the : first sheet in your Excel workbook? No, it only needs to work in 2003. Yes, we are connecting to a named range called CurrentData and it is in the first sheet of the workbook. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upon opening, can Word pull up same 4 documents automatically? | Microsoft Word Help | |||
Certain "word" documents opening in larger font and appearing bigg | Microsoft Word Help | |||
best way to handle five documents that need to be merged in the e. | Microsoft Word Help | |||
Opening templates as documents | Microsoft Word Help | |||
Sending Merged Documents to Printer Individually | Mailmerge |