Re: Envelope Mail Merge from .xls all records rather than selectio

Forget about the Wizard. You can do everything that you need to with the
toolbar.

--
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

"Kara" <Kara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:17712F05-1CAB-47C8-A26C-135957A5872D@xxxxxxxxxxxxxxxx
Doug,

Thank you, that works! Why is it different in the toolbar than going
through the mail merge wizard? It seems like it should be consistent in
either case.

"Doug Robbins - Word MVP" wrote:

From the View menu, select Toolbars and then check the Mail Merge item
and
use the Mail Merge toolbar. Then, use the third button from the left
(Mail
Merge Recipients) to select the records that you want to merge.

--
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

"Kara" <Kara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:61EF0401-F139-4E0F-8830-64618D1DED37@xxxxxxxxxxxxxxxx
I am working on a mail merge Word 2003 envelope document using an Excel
(.xls) datasource. I am having difficulty only printing or editing the
5
or
6 recipients I have selected out of the 1,000 recipients in the
datasource.
Below is the process that I am following and the only way that I can
get
it
to work is if I use a .csv rather than a .xls but I want the
spreadsheet
to
contain more than one workbook so a .csv will not work for me.

1- Open Word
2- Select Tools > Letters and Mailings > Mail Merge
3- Select Envelops as the Document type
4- Select Next: Starting document
5- Select Envelope size
6- Select Next: Select recipients
7- Browse to Excel (.xls) document
8- Select the correct worksheet
9- Select Clear All
10- Select 5 or 6 recipients
11- Select Next: Arrange your envelope
12- Arrange envelope
13- Select Next: Preview your envelopes
14- Select Next: Complete the merge
15- Select Edit individual envelopes
16- Select All merge records
17- Click OK

This then merges all 1000 records rather than the 5 or 6 selected.
How
do
I get it to consistently print or edit the selected recipients rather
than
the entire list?

Thanks,
Kara






.

Relevant Pages

  • Re: Mail Merge Issue - <Next Record>
    ... (are you using the task pane "Wizard", or the toolbar?) ... This reply is posted in the Newsgroup; ...
    (microsoft.public.word.vba.general)
  • Re: How do I make a list of people from an *.mdb recipients list
    ... In the first step of the Mail Merge Wizard, or using the first button on the ... Mail Merge toolbar, choose the "Directory" option. ... Peter Jamieson ... When I try to make a directory from the recipients' list each ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Choosing a different set of recipients
    ... > steer through the tortuous merge wizard? ... > should be able to change the recipients list at will from the toolbar. ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Your message did not reach some or all of the intended recipie
    ... recipients' email addresses, and try again to check if the issue can be ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... >> 6) Do you have Recovery Storage group enabled on the SBS server? ...
    (microsoft.public.windows.server.sbs)
  • Re: Wave 3 makes the Hotmail UI as convenient as punch cards
    ... recipients from the To, Cc, and Bcc *fields* within its UI. ... Once the aggregate list is compiled, the e-mail client sends a RCPT-TO ... That an input *field* in the user interface in the e-mail client lets ... this *newsgroup* don't know. ...
    (microsoft.public.internet.mail)