Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / February 2007

Tip: Looking for answers? Try searching our database.

working templates ?  General word vba question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
wbntravis - 20 Feb 2007 11:32 GMT
I am currently learning excel vba but a friend of mine has this problem in
Word.   She has a form letter where she has to fill in the person's name
their account number and the amount of the account.

These are the three things she needs to change in the form letter.
Then print the letter
I showed her where we put Name in the name place and then
use replace but she found that too hard.

Right now, she is phyisically changing the name, the account number
and the amount of the account using backspace.  Sometimes she
backs up to far and ruins the fom letter.

Should I be looking at a template? I dont know much about templates.
Surely there is a faster way to input the information and send
the letter off to the printer.

Thanks in advance
wbnTravis Oklahoma
Shauna Kelly - 20 Feb 2007 13:41 GMT
Hi wbntravis

The following may help:

How to create a Userform
http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

Hope this helps.

Shauna Kelly.  Microsoft MVP.
http://www.shaunakelly.com/word

>I am currently learning excel vba but a friend of mine has this problem in
> Word.   She has a form letter where she has to fill in the person's name
[quoted text clipped - 15 lines]
> Thanks in advance
> wbnTravis Oklahoma
Rob - 20 Feb 2007 15:52 GMT
You actually have several options. You can.. 1) do as Shauna suggested, 2)
add form fields and protect the document so it's not possible to backspace
too far, and  3) you can make a mail merge document using an excel
spreadsheet as the data source, typing into the spreadsheet and
printing/merging the document. Whichever is best/easiest/most useful.
ANDY - 20 Feb 2007 21:38 GMT
I would suggest to create a template and to use custom property fields.

If you are looking for a professional solution take a look here...

www.ODIS-Systems.com

> I am currently learning excel vba but a friend of mine has this problem in
> Word.   She has a form letter where she has to fill in the person's name
[quoted text clipped - 15 lines]
> Thanks in advance
> wbnTravis Oklahoma
wbntravis - 21 Feb 2007 07:57 GMT
Thanks all !

You narrowed down what I need to learn.   ( I am good at
userforms.)  Now I need to learn how to make a template
and how bookmarks work in Word

Thanks for the time saved by pointing me in the right
direction!

Signature

wbnTravis, from Oklahoma

> I would suggest to create a template and to use custom property fields.
>
[quoted text clipped - 21 lines]
> > Thanks in advance
> > wbnTravis Oklahoma
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.