Hello dear forum members,



I have been googling for a while to find a solution of automating the preparing of a quotation. I want to be able to prepare a table for the items and include the item description texts seperately for each item.

Lets say i have a hundred items in my main word document and each item is described in one page. When a costumer wants a quotation , i just want to click on item names and office will prepare price table from another excel sheet and will include item explanation pages from the main word document which includes all items and automatically will prepare the quotation.

So , is it possible ? How much can I automate and save time?

See Automated Boilerplate Using Microsoft Word and look at AutoText and Building Blocks.

If you want to truly automate it, you'll have to get into programming. See Create a Simple Userform.