Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Chris Chris is offline
external usenet poster
 
Posts: 237
Default Combining multiple mail merge doc's and then sorting by last name

I've got a mail merge that goes every week or so which I save each week. I
want at some point to take the mail merges and combine them all and then sort
by last name. Each document has a header and then under it the name (first
and last) and then address information then the body of the letter, etc. Is
there a way I can take these combined merges and alpha sort them by last
name? I can't seem to figure out how to do it, or if it's possible.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
PJY PJY is offline
external usenet poster
 
Posts: 306
Default Combining multiple mail merge doc's and then sorting by last name

The only way I know of, without putting your names into a table, is to do
this in your data source. If you click on Last Name in the data source it
will sort them alphabetically. However, that doesn't solve your problem about
combining them. You would have to combine all the data sources 1st, then
sort. The data source is saved to Access, so simply open one data source,
then copy and paste you other data sources into that one and save it as a new
data source. Hope that helps!

"Chris" wrote:

I've got a mail merge that goes every week or so which I save each week. I
want at some point to take the mail merges and combine them all and then sort
by last name. Each document has a header and then under it the name (first
and last) and then address information then the body of the letter, etc. Is
there a way I can take these combined merges and alpha sort them by last
name? I can't seem to figure out how to do it, or if it's possible.

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Combining multiple mail merge doc's and then sorting by last name

You mean that you want to combine a number of week's worth of letters and
have them appear in that documnet with all of the A's , then the B's etc?.

What would be easier would be to save all of the mail merge main documents,
then combine them and then execute a merge of the combined document.

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

"Chris" wrote in message
...
I've got a mail merge that goes every week or so which I save each week.
I
want at some point to take the mail merges and combine them all and then
sort
by last name. Each document has a header and then under it the name
(first
and last) and then address information then the body of the letter, etc.
Is
there a way I can take these combined merges and alpha sort them by last
name? I can't seem to figure out how to do it, or if it's possible.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Mail Merge records KFreds Mailmerge 6 September 17th 08 08:56 PM
Advanced Word 2003 Mail Merge: Combining Records [email protected] Mailmerge 10 January 25th 07 10:56 PM
combining lists in mail merge visiondoc Mailmerge 2 September 27th 06 06:50 AM
Combining multiple merge documents cth5c Mailmerge 1 June 15th 05 11:14 AM
Mail Merge with Multi Doc's on one page Lisa Microsoft Word Help 7 April 6th 05 03:49 PM


All times are GMT +1. The time now is 04:25 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"