Multiple templates using one datasource at the same time

C

cth5c

I have several Word templates that use a common Excel spreadsheet as their
data source. Can more than one template access the Excel spreadsheet at the
same time to do a mail merge? In other words, can I have more than one user
doing a mail merge with the same data source at the same time without having
to share the workbook? Right now, I get a message that the spreadsheet is
being used by another user. I am using Word 2002 and Excel 2002
 
M

Mark@ReiglerAli

We use a word document in table form which can be opened as read-only, we
manage to have several documents reading from it at once. Maybe you could
apply that to your Excel problem, have you tried setting the sheet to read
only?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Mail Merge Directory Conditional Page Break 0
Autonumber field in Excel that behaves the same as Access 0
Excel --> Word 4
Mail Merge Help 0
ASK Field Formatting 1
Indenting every other paragraph in Word at the same time? 0
Multiple templates with common styles 2

Top