Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-10-2013, 08:07 PM
leemoreau leemoreau is offline Any ability or plugins to have screen pops capture info to paste into a template? Windows 8 Any ability or plugins to have screen pops capture info to paste into a template? Office 2013
Novice
Any ability or plugins to have screen pops capture info to paste into a template?
 
Join Date: Sep 2013
Posts: 8
leemoreau is on a distinguished road
Default Any ability or plugins to have screen pops capture info to paste into a template?


Hi everyone,

I have a template in Word that has fields like customer name, customer address, customer first name etc, and it's basically a quote/letter so "Dear FirstName, your total price is XYZ price" etc.

Right now I just overwrite each field when I want to make a new quote. I guess this is sort of like mail merge I'm looking for but it's not for mass customers. I'm wondering if there's any way or any plug in that would pop up a screen that almost steps you though filling in the values, like the first pop up says "Customer First Name" and then "Customer Full Name", "Customer address" etc and you fill it in press enter and then when all are filled in, it adds them all to the Word document in the spaces mentioned. Is that possible with Word 2013 or with some sort of plug in for word? Thanks!
Reply With Quote
  #2  
Old 09-11-2013, 01:29 AM
Charles Kenyon Charles Kenyon is offline Any ability or plugins to have screen pops capture info to paste into a template? Windows Vista Any ability or plugins to have screen pops capture info to paste into a template? Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,082
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

What you are asking about is called a User Form.
Create a Simple Userform

If for any reason you can't use macros, look into the MacroButton Field. It allows you to create non-macro prompts. You can move to the next field using the F11 key.

BTW, I do use mailmerge for preparing things that go to one individual. The variable information is stored in an Excel worksheet. This is done when I have more than one document to prepare regarding the same information, sometimes over a period of time.
Reply With Quote
  #3  
Old 09-11-2013, 06:35 AM
leemoreau leemoreau is offline Any ability or plugins to have screen pops capture info to paste into a template? Windows 8 Any ability or plugins to have screen pops capture info to paste into a template? Office 2013
Novice
Any ability or plugins to have screen pops capture info to paste into a template?
 
Join Date: Sep 2013
Posts: 8
leemoreau is on a distinguished road
Default

That worked great thanks! The userforms are perfect. The only issue I have is that if I insert a DocVariable into word, it makes it bold. When there's no variable it says "Error! No document variable supplied." which I'd prefer to have as the default when you open it. The problem is when I run the macro, every variable field is bolded. Before running the macro, I can click each word one at a time in the Error!, No, document, variable etc and unbold it and save. When I run the macro it keeps it unbolded. When I modify the fields they stay unbolded, but if I run the macro and clear all the fields and run it to erase them all, they go back to bold. Not a huge issue as we'd open the file and it would be formatted properly, run the macro and we are good, but any reason that when I enter a blank variable value and it goes back to the "Error!" message, that it always makes it go back to bold?

I just noticed that it's only on some fields, like a few of them stay unbolded all the time but others go back, so thinking it must be some kind of formatting issue on the page?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word template with ability to pick optional text FormLetters Mail Merge 1 09-29-2013 07:51 PM
When I cut and paste to a template it wrecks the template jolyon39 Word 3 10-19-2012 03:12 PM
Any ability or plugins to have screen pops capture info to paste into a template? Capture a Font in a Variable joatmon Excel Programming 1 05-30-2012 08:23 PM
How to capture start and ending Ref. Nos. in an array KIM SOLIS Excel 5 09-07-2011 07:43 AM
Some info only visible in print preview or full screen view Cody_Anderson Word 2 12-15-2010 01:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 PM.


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