Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2015, 12:17 PM
torma156 torma156 is offline Create custom quote based on template Windows 10 Create custom quote based on template Office 2013
Novice
Create custom quote based on template
 
Join Date: Sep 2015
Posts: 2
torma156 is on a distinguished road
Default Create custom quote based on template

Hello,

I'm already playing a long time with the idea of creating a "quote generator" in Word 2013.
I want to create 1 master document (template?) which I want to keep up to date. This document would contain:

- First page containing logo, name & contact details of the customer and the document creator details
- Content table
- An introduction text containing the name of the customer
- All different chapters (Heading + text/pictures/tables) describing my quote details & pricing for each possible offering my company has (e.g. chapters 1, 2, 3, 4, 5, 6)
- A pricing summary



Like I said earlier, I want to keep this (and only this) document up to date as a master document but whenever I create a new quote for one particular customer, I would like to receive a possibility (checkboxes, selecting building blocks, I don't know how...) to:

- Provide the entries for which customer I will created this quote (Company A - Addressline B)
- Select only the relevant chapters I want to include into this offer (e.g. chapter 1, 3, 4 and 6)
- The content table and the pricing summary should be adapted based on the choices I have made within the chapters part.

I have no idea how I should start with this:

- Use template functionalities?
- Use building blocks?
- Use VBA functionality?
- Use Task Pane?

Can somebody please help me get started?

Kind regards,

Nico

Last edited by Charles Kenyon; 09-06-2015 at 04:50 PM. Reason: Mark as solved
Reply With Quote
  #2  
Old 09-05-2015, 09:34 PM
gmayor's Avatar
gmayor gmayor is offline Create custom quote based on template Windows 7 64bit Create custom quote based on template Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,103
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

I would create a userform (or forms) that provide the interaction between the user the data and the document and complete the document based on selections. To see what I mean, see the illustrations in my web site at http://www.gmayor.com/Invoicer.htm. This of course is for invoicing, but a quote is little different from an invoice so the principles could apply.

To get you started, see http://www.gmayor.com/Userform.htm then for greater depth see http://gregmaxey.com/word_tip_pages/..._userForm.html and http://gregmaxey.com/word_tip_pages/...pass_data.html
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 09-06-2015, 04:31 AM
Charles Kenyon Charles Kenyon is offline Create custom quote based on template Windows 8 Create custom quote based on template Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,136
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

The suggestions that Graham made will give you the best result. While there are other methods that could give you bits and pieces of a solution, a userform can put it all together.
Reply With Quote
  #4  
Old 09-06-2015, 11:04 AM
torma156 torma156 is offline Create custom quote based on template Windows 10 Create custom quote based on template Office 2013
Novice
Create custom quote based on template
 
Join Date: Sep 2015
Posts: 2
torma156 is on a distinguished road
Default Thanks

Thanks guys, I will give this a try.

Nico
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create custom quote based on template Default Custom Dictionary Based on Document PatrickYork Word 3 04-03-2015 11:19 PM
Create custom quote based on template Insert image based on document custom property anandyrh Word 1 08-14-2013 12:08 AM
Create custom quote based on template How to create a MS Word Template with custom designs in the background? pwall1115 Word 3 04-14-2013 08:45 PM
Create Custom Word Template emilyrogers Word 0 02-16-2011 05:46 AM
Template "File In Use" when opening 2 documents based on the same template wendt Word 5 12-15-2009 12:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft