Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2015, 09:05 PM
MauriceP MauriceP is offline Create Letters From Content Menu Windows 10 Create Letters From Content Menu Office 2013
Novice
Create Letters From Content Menu
 
Join Date: Oct 2015
Posts: 3
MauriceP is on a distinguished road
Default Create Letters From Content Menu

I have created over 60 business letter templates with slight variations in each depending on a variety of situations.

Is there a way that I can have one template but select off a menu the various content elements I need and have the text inserted into the letter?



The letter will need to be editable and also has some mail merge.
Reply With Quote
  #2  
Old 10-19-2015, 09:17 PM
gmayor's Avatar
gmayor gmayor is offline Create Letters From Content Menu Windows 7 64bit Create Letters From Content Menu Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
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

The answer is almost certainly yes. You could employ a userform to select the variations ane write them to various parts of the document, or as you have already gone to the trouble of creating the templates, you could add a ribbon tab to the ribbon with a menu system to call the required template.

Mail merge may create some issues in this context, but probably not insurmountable ones. We would need more information.

Start with http://www.gmayor.com/Userform.htm and http://www.gmayor.com/Userform_ComboBox.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 10-19-2015, 10:05 PM
MauriceP MauriceP is offline Create Letters From Content Menu Windows 10 Create Letters From Content Menu Office 2013
Novice
Create Letters From Content Menu
 
Join Date: Oct 2015
Posts: 3
MauriceP is on a distinguished road
Default

What do you think about Content Controls? Does that do the same thing?
Reply With Quote
  #4  
Old 10-20-2015, 08:14 AM
Charles Kenyon Charles Kenyon is offline Create Letters From Content Menu Windows 8 Create Letters From Content Menu Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
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

Quote:
Originally Posted by MauriceP View Post
What do you think about Content Controls? Does that do the same thing?
Ahhh.... no.
Reply With Quote
  #5  
Old 10-20-2015, 08:27 AM
Charles Kenyon Charles Kenyon is offline Create Letters From Content Menu Windows 8 Create Letters From Content Menu Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
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

For someone without programming experience, userforms can be daunting.
It is the most elegant solution to what you are trying to do, though.

A much more complex solution would not require macros. You would need ASK fields combined with IF Fields. This is more painful to use because there will be a series of ASK response boxes popping up. This is still a type of programming, but it is all done within the Word document. It does not give you a menu, it gives a series of questions. IF fields are case-sensitive in their tests. The ASK field predates Windows and is not fun.

I recommend biting the bullet and using a UserForm.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Letters From Content Menu How can a document have the same date modified/create date, yes have have actual file content? legaleagle Word 15 01-07-2015 06:58 PM
Create Letters From Content Menu Create content control for clip art not a picture from file... swissmiss Drawing and Graphics 3 11-01-2013 05:43 PM
Create Letters From Content Menu how to create menu shortcut to insert specific picture msworddave Word 1 05-08-2013 02:00 AM
Adding Macro menu to the right click menu (Word 2007) masam123 Word 0 10-14-2011 04:05 AM
Create Custom menu using a macro twnty2 PowerPoint 0 06-29-2011 04:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:42 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