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: 3,301
gmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to all
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: 6,938
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
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: 6,938
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
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 - Senior Forums

All times are GMT -7. The time now is 09:33 AM.


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