Merge does not stop at "to" value

S

Sue

I have asked this question but it seems to have disappeared and I know
neither where nor the answer! Sorry folks.

I have a macro that merges "from" and "to" to make a form letter. This
works. But it must also list the persons sent their letters in a separate
"next" merge listing all the names on one page. This starts at "from" but
does not stop until the last record. Why does it not stop at the "to" value?

I have tried this not in the macro. Using word merge to a new document it
does the same thing. The list of names starts at the "from" but does not stop
at "to" but goes on to the last record.

How can I make it stop at the "to" value?
 
D

Doug Robbins - Word MVP

Here is the response that I posted to your previous question:

Using the UI Word Merge to New Document facility and selecting just a range
of records that does not extend to the last record in the data source only
creates a letter for each of the records in the range of records specified
by the From ...To of the Merge to New Document dialog when I try it.

However show us the code that you are using.

I suggest that you access the newsgroups via Outlook Express or Windows Mail

1.1. Connect to a newsgroup server using Outlook Express
Open Outlook Express and follow these steps:
1. On the Tools menu, click Accounts.
2. In the Internet Account dialog box, click Add, and then click News.
The Internet Connection Wizard starts. Follow these steps in the wizard:
1. On the first screen, in the Display name box, type the name that other
users will see when you post a message to the newsgroup, and then click
Next.
2. On the second screen, type your full e-mail address in the E-mail address
box, and then click Next.
3. On the third screen, in the News (NNTP) Server box, type the name of your
news server. To subscribe to the newsgroups hosted on Microsoft's servers,
type msnews.microsoft.com. If you don't know the name of your news server,
contact your Internet provider.
4. If necessary, select the My news server requires me to log on check box,
and then click Next. If you don't know whether your server requires you to
log on, contact your Internet provider. The Microsoft server does not
require a user name and password.
5. On the last screen, click Finish.
3. Click Close, and then click Yes when asked if you want to download
newsgroups from the account you just created. The Newsgroup Subscriptions
dialog box appears.
4. Select the newsgroups you want to use, click Subscribe, and then click
OK.

Note Most of Microsoft newsgroups use this naming convention:
microsoft.public.application_name.specific_area. For example: you could
subscribe to microsoft.public.office.dataanalyzer, or
microsoft.public.excel.programming. However, that isn't always the case.
Don't be afraid to browse the list of groups in order to find something that
you think will be useful.

5. On the Tools menu, click Options, click the Read tab, and then clear the
Get 300 headers at a time check box.
6. Click the Maintenance tab, clear the Delete new messages n days after
being downloaded check box, and then click OK.
Step 5 allows you to download and read all the newsgroup's postings when you
first subscribe. Step 6 allows you to read older messages.
1.2. Subscribe or unsubscribe to newsgroups
After you establish a connection to your newsgroup server, you add
newsgroups to your list by subscribing. You can subscribe or unsubscribe to
newsgroups at any time. Typically, you use the group name as a guide when
subscribing. For example, a name such as
microsoft.public.office.developer.outlook.forms would be a good place to
start if you need help writing a custom form for Outlook.
To subscribe
1. Start Outlook Express.
2. In the folder pane, click the name of your news server. For example, if
you established a connection to Microsoft's server, click
msnews.microsoft.com.
3. In the main viewing pane, click Newsgroups.
4. In the Newsgroup Subscriptions dialog box, select a newsgroup from the
list, and then click Subscribe.
5. Repeat the previous step to subscribe to additional newsgroups, and then
click OK when you finish.
6. In the main viewing pane, double-click the name of the new newsgroup. If
you only want to receive new messages since the last time you visited,
select the New messages only check box, and then double-click the newsgroup
name.

Note When you subscribe to a newsgroup for the first time, you receive all
the messages whether or not you select the New messages only check box.
To unsubscribe
• In the Outlook Express folder pane, right-click the newsgroup that you
want to stop using, and then click Unsubscribe on the shortcut menu.
Tips
• To reduce the number of items in the list of available newsgroups, enter a
phrase in the Display newsgroups which contain box. For instance, you can
enter an application name such as "publisher" or the name of a discipline
such as "programming." The list changes automatically when you finish
typing.
• Newsgroups in languages other than English are identified by their names;
for example, microsoft.public.fr.excel is a newsgroup for Microsoft Excel
users who speak French.


--
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, originally posted via msnews.microsoft.com
 
S

Sue

I am sorry I did not make myself clear.

I said, and agree that Using the UI Word Merge to New Document facility and
selecting just a range of records that does not extend to the last record in
the data source only creates a letter for each of the records in the range of
records specified by the From ...To of the Merge to New Document dialog when
I try it. . . .

.. . . However when I use the UI Word Merge to New Document facility and
select a range of records that does not extend to the last record in the data
source to list all the names and assigned membership numbers on one page (or
however many pages it takes, presently 2) it does not stop at the "to" field.
ie my problem is when I am merging

{mergefield "FirstName"} {mergefield "Surname"} {mergefield "CardNum"}
{Next}{mergefield "FirstName"} {mergefield "Surname"} {mergefield "CardNum"}
{Next} etc (this is in a table). The purpose of which is list the new
members joining in the last or previous month or year. My code performs the
same as using the UI which I don't understand why it won't stop at the "to"

Re Newsgroups could I ask a general question - is this viable for those who
have a very slow dial up connection - anything more than 500K is too much.
 
D

Doug Robbins - Word MVP

Hi Sue,

As far as I can tell, the first two paragraphs of your response say the same
thing.

However, it is the use of the { NEXT } fields that are causing it to go of
the rails. Rather that using a multiple row table, containing { NEXT }
fields, use a one row table in a Directory type mail merge main document.
When you execute the merge of such a document, the new document that is
prepared will contain a row of data for each record in the data source from
the "From" record to the "To" record only.

Re the newsgroups, that method of accessing them was the way it was back in
the days of slow (300 Baud) dial-up modems.

--
Hope this helps

Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to avail yourself of my
services on a paid, professional basis.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top