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 / Mailmerge and Fax / May 2006

Tip: Looking for answers? Try searching our database.

Print envelope from form letter

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DaveG - 02 May 2006 16:36 GMT
I have a form letter (word template)  that I fill out and mail out to people.
Within the form letter I type the recipients address. When I print the letter
I would also like to print an envelope with the recipients address on it.

Thanks

Dave
Charles Kenyon - 02 May 2006 17:50 GMT
And what prevents you from doing this?

Version of Word?

By "word template" do you mean a protected form? (If so, "template" means
something entirely different in Word-ese, which calls what you are talking
about an "online form.")
Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

>I have a form letter (word template)  that I fill out and mail out to
>people.
[quoted text clipped - 5 lines]
>
> Dave
DaveG - 02 May 2006 18:36 GMT
Thanks Charles, Yes I am using a protected form. I am using Word 2000. The
option under tools "Envelopes and Labels" is not active when using the
protected document.

> And what prevents you from doing this?
>
[quoted text clipped - 12 lines]
> >
> > Dave
Charles Kenyon - 02 May 2006 19:47 GMT
OK. That takes programming. What is below is the code I use for this. Note,
I only have three address lines in my form. These are Name, Street, and CSZ.
If you have more you'll need to make sure your envelope has fields to match.

It calls up a custom envelope template that I use. That template has
macrobutton fields for manual data entry. See
http://www.addbalance.com/usersguide/fields.htm#MacroButton,
http://www.gmayor.com/Macrobutton.htm and
http://www.mvps.org/word/FAQs/TblsFldsFms/UsingMacroButton.htm for more
about macrobutton fields.

Sub KenyonBillEnvelope()
'
' KenyonEnvelope Macro
' Macro written 7/5/02 by Charles Kyle Kenyon
' "&chr(10)&"New envelope based on Kenyon Envelope form
'   Calls WorkgroupPath Function (below)
'   Calls SelectIt subroutine (below)
'
   Dim sTemplatesPath As String
   Dim sName As String
   Dim sAddress As String
   Dim sCSZ As String
'
   sTemplatesPath = WorkGroupPath & "Letters & Faxes\"
'
'   Get address info from bill
'
   sName = ActiveDocument.FormFields("Name").Result
   sAddress = ActiveDocument.FormFields("Street").Result
   sCSZ = ActiveDocument.FormFields("CSZ").Result
'
'   Create new envelope document and go to place for inserting address
   Documents.Add Template:= _
       sTemplatesPath & "Kenyon Legal Envelope.dot", _
       NewTemplate:=False
   SelectIt (2)
'
'
   Selection.Text = sName
   SelectIt (2)
   Selection.Text = sAddress
   SelectIt (2)
   Selection.Text = sCSZ
   SelectIt (2)
   Selection.Text = ""
   SelectIt (2)
   Selection.Text = ""
   SelectIt (1)
   Selection.Fields.Add Range:=Selection.Range, _
       Type:=wdFieldEmpty, _
       Text:="BARCODE \u """ & sCSZ & """", _
       PreserveFormatting:=False
End Sub

Function WorkGroupPath() As String
'   Written by Charles Kenyon
'   February 28, 2003
'
'   Used by templates menus to set location of templates.
'   Returns workgroup tempates path with "\" at the end.
'
'   This is needed because if the folder is a network drive rather
'   than a folder, it will have the "\" already. If it is a folder,
'   it will not have the backslash. This function gives a string
'   with the backslash in either case.
'
   WorkGroupPath =
Application.Options.DefaultFilePath(wdWorkgroupTemplatesPath)
   If Right(WorkGroupPath, 1) <> "\" Then
       WorkGroupPath = WorkGroupPath & "\"
   End If
End Function

Private Sub SelectIt(iField As Integer)
'   Routine goes to beginning of document and then goes to field
'   iField sets number of field to go to
'   Used in new document menus where fields are present
'   Note - no error handlers so you better have the fields
'
   Dim iNumber As Integer
   Selection.HomeKey Unit:=wdStory
   For iNumber = 1 To iField
       Selection.NextField.Select
   Next iNumber
End Sub

See http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm or
http://gmayor.com/installing_macro.htm for information on how to put these
in your templates. You can download some sample envelope templates from
http://gmayor.com/Zips/Envelope.zip.
Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> Thanks Charles, Yes I am using a protected form. I am using Word 2000. The
> option under tools "Envelopes and Labels" is not active when using the
[quoted text clipped - 18 lines]
>> >
>> > Dave
 
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.