|
|
#4
08-10-2018, 03:49 PM
|
||||
|
||||
Try changing:
.OpenDataSource Name:=strWorkbookName, AddToRecentFiles:=False, _ to: .OpenDataSource Name:=strWorkbookName, ReadOnly:=True, AddToRecentFiles:=False, _ PS: When posting code, please use the code tags, indicated by the # button on the posting menu. Without them, your code loses much of whatever structure it had.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Tags |
| mail merge, vba |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Suppress blank lines in mailmerge of excel reports into word document
|
beefcake2000 | Mail Merge | 1 | 11-10-2017 12:54 PM |
| Master template and subtemplate docs | ab-os | Word | 1 | 05-02-2017 01:23 PM |
|
Template From MailMerge Document
|
LouGibson | Mail Merge | 1 | 06-13-2016 03:14 PM |
| how to copy addresses in word document to excel/mailmerge list | msnarayanan | Mail Merge | 4 | 10-17-2015 03:17 PM |
|
Excel, transfer data from Master Sheet to sub sheets, using key word from column
|
anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode