Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2009, 09:42 AM
happymouth happymouth is offline Letter Templates Windows XP Letter Templates Office XP
Novice
Letter Templates
 
Join Date: May 2009
Posts: 5
happymouth is on a distinguished road
Question Letter Templates


I currently use a template letter that I have made to respond to applications (rejection letters). However, it is time consuming and I am positive there is a quicker way than just inputting address after address. Is there a software or something that can help me do this quicker? Like a pop-up form, so I don't have to tab/enter/scroll down to the fields I need to fill out.
I know this has quite a few possiblities that I haven't even begun to think of, I was wondering where to start.
Thanks for any help!

Last edited by Bird_FAT; 05-20-2009 at 12:12 PM.
Reply With Quote
  #2  
Old 05-15-2009, 02:28 PM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Letter Templates Letter Templates Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Could you post the template letter so that we can see what you already have?!
Reply With Quote
  #3  
Old 05-15-2009, 02:32 PM
happymouth happymouth is offline Letter Templates Windows XP Letter Templates Office XP
Novice
Letter Templates
 
Join Date: May 2009
Posts: 5
happymouth is on a distinguished road
Default Letter Templates

Thanks for your help!
Attached Files
File Type: doc Application Response Letter 2.doc (28.0 KB, 33 views)
Reply With Quote
  #4  
Old 05-16-2009, 05:20 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Letter Templates Letter Templates Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

I have created a form that opens with the document - it has sections for name and address. You use the tab button to move through the boxes and click OK to enter the data into the document.

It has a clear button to empty the data boxes, and a cancel button to enable the user to alter manually if they wish!


To make something like this all work, you add bookmarks to where you want the text boxes to enter the data (you can add in as many added boxes and bookmarks as you like), then tell the form to enter the data at the bookmark location/s of your choice!

If you need any help understanding the VBA script, then just add your questions to this thread so that others can see them!
Attached Files
File Type: doc Application Response Letter (Automated).doc (44.0 KB, 48 views)
Reply With Quote
  #5  
Old 05-16-2009, 09:52 AM
happymouth happymouth is offline Letter Templates Windows XP Letter Templates Office XP
Novice
Letter Templates
 
Join Date: May 2009
Posts: 5
happymouth is on a distinguished road
Default Sorry!

Sorry, maybe I am doing something wrong. The document opens with the control toolbox shown, but nothing else. I don't see where to add the information to the form. I can show the address form in the VBA code & know it's there - but I don't know how to pull it up?

Thanks for any and all help!
Reply With Quote
  #6  
Old 05-16-2009, 10:26 AM
happymouth happymouth is offline Letter Templates Windows XP Letter Templates Office XP
Novice
Letter Templates
 
Join Date: May 2009
Posts: 5
happymouth is on a distinguished road
Default Got it!

Yep...my fault. I did not save it as a template. As soon as I did, the form opened for me beautifully. It works great, and I am looking into learning how to code it myself. Thanks so much! Will be sure to up your rep!
Reply With Quote
  #7  
Old 05-16-2009, 10:46 AM
happymouth happymouth is offline Letter Templates Windows XP Letter Templates Office XP
Novice
Letter Templates
 
Join Date: May 2009
Posts: 5
happymouth is on a distinguished road
Default I'm back.....

Am I able to bring the form back up again? I can't seem to do that. I want to be able to enter the information, print the page, re-open the form, clear the information and start all over. Sorry, I've kind of went all over to figure this out & just came back here.
Reply With Quote
  #8  
Old 05-16-2009, 03:09 PM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Letter Templates Letter Templates Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Quote:
Originally Posted by happymouth View Post
Am I able to bring the form back up again? I can't seem to do that. I want to be able to enter the information, print the page, re-open the form, clear the information and start all over. Sorry, I've kind of went all over to figure this out & just came back here.

Are you looking for it to print on close and then open a new form?
I'm a bit busy right now - but I could alter it to do that in the morning and post it then if you want?
Reply With Quote
  #9  
Old 05-17-2009, 02:43 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Letter Templates Letter Templates Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default Updated Version

Here you go happymouth,

An updated version - it now has an extra button on the form. Your options are now:
  1. OK - Enter the form data and close the form (allows you to manually edit the form before printing - just in case)
  2. Clear - clear the data from the form, but keep it open (In case of mistakes)
  3. New - enter the data from the form, print the document, clear the data from the letter and form (so you can do multiple letters in one sitting)
  4. Cancel - Closes the form and the document [NOTE: IT DOES NOT SAVE THE DOCUMENT, NOR ASK TO] (for when you have finished)
As before - open and then save as a Template (this puts it in your Templates folder)

If you look in the coding, I have annotated each section for you, so that you can decipher it easier. There are two sections of code - one in the form itself, the other in 'This Document' - look for both in the left-hand explorer window in the VBA Editor.

Hope this helps!


ERROR: THE (v2).doc VERSION CONTAINS AN ERROR IN THE VBA CODING - PLEASE ENSURE THAT YOU HAVE THE *(v2.1).doc VERSION
Attached Files
File Type: doc Application Response Letter (Automated v2.1).doc (58.0 KB, 75 views)

Last edited by Bird_FAT; 05-18-2009 at 07:14 AM.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
company standard letter nicklarzn Word 0 12-17-2008 02:35 AM
Templates: automatic text generation from Rich Text content control Chickenmunga Word 0 10-01-2008 11:16 AM
capitalize first letter of sentences norco1 Word 0 06-25-2006 12:37 PM
How do i make outlook templates swiftmed Outlook 0 02-23-2006 06:47 AM

Other Forums: Access Forums

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