A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

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 » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mail Merge Recipient Problems



 
 
Thread Tools Display Modes
  #1  
Old May 10th 07, 05:30 AM posted to microsoft.public.word.mailmerge.fields
Bec
external usenet poster
 
Posts: 12
Default Mail Merge Recipient Problems

Currently using Word 2002 I created my mail merge and data source. For some
reason it keeps moving my current recipients that I have finished entering to
the beginning of the recipient list. My recipient was up to 4000 so I created
a new one it was working fine then started to do this. I have sorted the
records so the appear how and where I want. But as soon as I go out of the
file and then back in again it's all jumbled. Please HELP!!!
Ads
  #2  
Old May 10th 07, 08:25 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,832
Default Mail Merge Recipient Problems

One thing that you could do is use the data source with a Directory type
mailmerge main document in which you set up the merge fields in the cells of
a one row table. When you execute that merge to a new document, that
document will contain a row of data for each record in the data source. You
can then insert a row at the top of that table into which you insert the
names of the merge fields and then use the TableSort facility in Word to
get it into the order that you want.

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

"Bec" wrote in message
...
Currently using Word 2002 I created my mail merge and data source. For
some
reason it keeps moving my current recipients that I have finished entering
to
the beginning of the recipient list. My recipient was up to 4000 so I
created
a new one it was working fine then started to do this. I have sorted the
records so the appear how and where I want. But as soon as I go out of the
file and then back in again it's all jumbled. Please HELP!!!



  #3  
Old May 10th 07, 11:21 PM posted to microsoft.public.word.mailmerge.fields
Bec
external usenet poster
 
Posts: 12
Default Mail Merge Recipient Problems

Thanks Doug,

Whilst this may solve the problem in the short term it won't help me in the
long term. I use mail merge everyday and it's part of my normal duties so
will be a pain to have to do this everytime I use it. I have opened the data
source in Access and sorted it the way it needs to be but when I save it and
then go back to word to open the data source it's not the saved file. Is
there anyway for this to work and how?

"Doug Robbins - Word MVP" wrote:

One thing that you could do is use the data source with a Directory type
mailmerge main document in which you set up the merge fields in the cells of
a one row table. When you execute that merge to a new document, that
document will contain a row of data for each record in the data source. You
can then insert a row at the top of that table into which you insert the
names of the merge fields and then use the TableSort facility in Word to
get it into the order that you want.

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

"Bec" wrote in message
...
Currently using Word 2002 I created my mail merge and data source. For
some
reason it keeps moving my current recipients that I have finished entering
to
the beginning of the recipient list. My recipient was up to 4000 so I
created
a new one it was working fine then started to do this. I have sorted the
records so the appear how and where I want. But as soon as I go out of the
file and then back in again it's all jumbled. Please HELP!!!




  #4  
Old May 10th 07, 11:40 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Mail Merge Recipient Problems

Sorting your data source in Access probably isn't going to be enough,
because Access tables have no "natural" sequence.

What is more likely to work is...
1. to create an Access query that
a. selects all the records from the table you want to use
b. specifies the sort sequence you want

and

2. to use that query as your data source.

If that doesn't work, sorry...

Peter Jamieson


"Bec" wrote in message
...
Thanks Doug,

Whilst this may solve the problem in the short term it won't help me in
the
long term. I use mail merge everyday and it's part of my normal duties so
will be a pain to have to do this everytime I use it. I have opened the
data
source in Access and sorted it the way it needs to be but when I save it
and
then go back to word to open the data source it's not the saved file. Is
there anyway for this to work and how?

"Doug Robbins - Word MVP" wrote:

One thing that you could do is use the data source with a Directory type
mailmerge main document in which you set up the merge fields in the cells
of
a one row table. When you execute that merge to a new document, that
document will contain a row of data for each record in the data source.
You
can then insert a row at the top of that table into which you insert the
names of the merge fields and then use the TableSort facility in Word to
get it into the order that you want.

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

"Bec" wrote in message
...
Currently using Word 2002 I created my mail merge and data source. For
some
reason it keeps moving my current recipients that I have finished
entering
to
the beginning of the recipient list. My recipient was up to 4000 so I
created
a new one it was working fine then started to do this. I have sorted
the
records so the appear how and where I want. But as soon as I go out of
the
file and then back in again it's all jumbled. Please HELP!!!





 




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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding new recipient to mail merge charlie Mailmerge 1 December 4th 06 11:04 AM
Mail merge data not showing on Mail Recipient List Connie G Mailmerge 6 October 26th 06 04:17 PM
Mail Merge Recipient List Jim Laumann Mailmerge 3 January 15th 06 02:31 PM
Mail Merge Recipient List Lambi000 Mailmerge 2 April 19th 05 12:35 PM
Mail Merge Recipient List Mark Mailmerge 3 April 6th 05 10:12 AM


All times are GMT +1. The time now is 01:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.