A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

re-choosing mail merge recipients



 
 
Thread Tools Display Modes
  #1  
Old September 10th, 2009, 09:17 PM posted to microsoft.public.word.mailmerge.fields
blawhon
external usenet poster
 
Posts: 9
Default re-choosing mail merge recipients

I have completed a Word 2003 mail merge to a letter where I've chosen some
recipients. Question: How do I keep from rechoosing the same recipients
when I create a #10 envelope mail merge with the same recipients? Thank you
in advance for your expertise! B
  #2  
Old September 11th, 2009, 08:01 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default re-choosing mail merge recipients

a. Which version of Word?
b. What type of data source? (Word? Office Address List? Excel?
Outlook? etc..., or could it be any type?)
c. Are you using the default connection method or choosing a
particular one (e.g. DDE for an Excel data source?)
d. Are you applying any filter criteria or sorting?
e. Are you selecting individual records, e.g. in the Recipents dialog box?

If you can answer those questions it might be possible to put together a
bit of VBA that might help, assuming that you know how to make use of
VBA macros.

Otherwise, I doubt if there is a simpler, more reliable way than doing
the obvious manual method of
a. closing the letter mail merge main document (primarily to release
the data source, which will probably be locked)
b. opening the envelope mail merge main document
c. selecting the same data source and applying the same sorts and
filters as you did for the letter

Another manual way that looks even more tedious and unreliable to me
would be to maintain two documents with the necessary merge fields - one
for the letter and one for the envelope. Then
a. open your letter, select the data source and filter as necessary
b. do your letter merge
c. delete everything in your letter
d. open your envelope document and edit-copy/edit-paste the entire
contents into the "letter" document
e. alter the merge document type using the first button in the mail
merge toolbar (View Toolbars to enable it if you don't see it)
f. do the envelope merge


Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

blawhon wrote:
I have completed a Word 2003 mail merge to a letter where I've chosen some
recipients. Question: How do I keep from rechoosing the same recipients
when I create a #10 envelope mail merge with the same recipients? Thank you
in advance for your expertise! B

  #3  
Old September 11th, 2009, 08:35 PM posted to microsoft.public.word.mailmerge.fields
blawhon
external usenet poster
 
Posts: 9
Default re-choosing mail merge recipients

a. 2003; b. Data source is Word save to local; c. ? d. no filter, I choose
recipients by checking the box left of the name; No sort; Yes, selecting
individual records in recipient box;

I will have to try your suggestion below on next mail merg - thank you!!

"Peter Jamieson" wrote:

a. Which version of Word?
b. What type of data source? (Word? Office Address List? Excel?
Outlook? etc..., or could it be any type?)
c. Are you using the default connection method or choosing a
particular one (e.g. DDE for an Excel data source?)
d. Are you applying any filter criteria or sorting?
e. Are you selecting individual records, e.g. in the Recipents dialog box?

If you can answer those questions it might be possible to put together a
bit of VBA that might help, assuming that you know how to make use of
VBA macros.

Otherwise, I doubt if there is a simpler, more reliable way than doing
the obvious manual method of
a. closing the letter mail merge main document (primarily to release
the data source, which will probably be locked)
b. opening the envelope mail merge main document
c. selecting the same data source and applying the same sorts and
filters as you did for the letter

Another manual way that looks even more tedious and unreliable to me
would be to maintain two documents with the necessary merge fields - one
for the letter and one for the envelope. Then
a. open your letter, select the data source and filter as necessary
b. do your letter merge
c. delete everything in your letter
d. open your envelope document and edit-copy/edit-paste the entire
contents into the "letter" document
e. alter the merge document type using the first button in the mail
merge toolbar (View Toolbars to enable it if you don't see it)
f. do the envelope merge


Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

blawhon wrote:
I have completed a Word 2003 mail merge to a letter where I've chosen some
recipients. Question: How do I keep from rechoosing the same recipients
when I create a #10 envelope mail merge with the same recipients? Thank you
in advance for your expertise! B


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.