Doug Robbins - Word MVP;2649433 Wrote:
I think that it would be better to put the details of the events and the
pricing into a Word template from which the users create the document
that
they want to merge with the client data.
The template should be stored in a folder on your network and that
folder
should be selected as the Work Group Templates Folder under
ToolsOptionsFile Locations in Word
That is probably quite satisfactory for 3 users. However, another
method of
distributing the template is given in the article "Distributing macros
to
other users" at:
http://www.word.mvps.org/FAQs/Macros...buteMacros.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Howard101" wrote in message
...-
I currently have an excel spreadsheet that I use as a database for
clients and I use Word for Proposals, Invoices and the like via a
mail
merge command that pulls in the relevant client line details into the
Word document.
I now require to put a section on the database spreadsheet which will
merge in all the pricing details of our various events. So when I
need
to make changes it is updated only in one place and it affects
everyone's documents accessing the database on the network (Only 3
users). However, this would obviously need to be done with absolute
cell addressing (something like $A$1). How do I do this in a mail
merge
type environment?
Any input would be greatly appreciated.
Howard
--
Howard101 -
Hi Doug
I have prices on sheet2 in Excel and need to merge the Prices into a
Word Document. When there is a price change I need it to update the
Word Document.
Your assistance will be most appreciated
Regards
Howard
--
Howard101