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 2008

Tip: Looking for answers? Try searching our database.

Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Trina - 28 May 2008 21:45 GMT
When I am doing a large batch of letters and I want to create envelopes, can
I do them at the same time?

My data source is very large and I don't send letters to everyone in the
data source each time.  So I open the source and pick the ones I want and
print the letters.  Then I have to open my data source again and re-select
the names so I can do envelopes.  I am doing 60 or so letters at a time.

I am sure there is a better way.
Doug Robbins - Word MVP - 29 May 2008 00:53 GMT
You could add an envelope to the mail merge main document (Tools>Letters and
Mailings>Envelopes and Labels>Envelopes>Add to Document) and set up the
merge fields for the address in the envelope that will be added at the
beginning of your document.

If your printer cannot handle the mixture of envelopes and letters, execute
the merge to a new document and then use the following macros to print the
envelopes and the letters separately.

Sub PrintEnvelopes()
Dim i as Long
With ActiveDocument
   For i = 1 to .Sections.Count - 1 Step 2
       .PrintOut Range: = wdPrintFromTo, From: = "s" & i", To: = "s" & i
   Next i
End With
End Sub

Sub PrintLetters()
Dim i as Long
With ActiveDocument
   For i = 2 to .Sections.Count Step 2
       .PrintOut Range: = wdPrintFromTo, From: = "s" & i", To: = "s" & i
   Next i
End With
End Sub

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When I am doing a large batch of letters and I want to create envelopes,
> can
[quoted text clipped - 6 lines]
>
> I am sure there is a better way.
 
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.