Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2013, 03:36 AM
redzan redzan is offline Sorting a mail merge by a specific number in the document Windows 7 32bit Sorting a mail merge by a specific number in the document Office 2003
Advanced Beginner
Sorting a mail merge by a specific number in the document
 
Join Date: Feb 2012
Posts: 37
redzan is on a distinguished road
Default Sorting a mail merge by a specific number in the document


Hopefully I can explain this. I have a mail merge document with 50 letters. I need to reorder them by a number in the document.

Example line in the text of my letter:

Cordially,

Jane Doe, MD
#jdoe1234

The number that they need to be reordered by is jdoe1234 ascending.
Reply With Quote
  #2  
Old 05-16-2013, 08:32 AM
macropod's Avatar
macropod macropod is offline Sorting a mail merge by a specific number in the document Windows 7 32bit Sorting a mail merge by a specific number in the document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You can use the mailmerge tools (Edit Recipient List) to sort on the field containing the #jdoe1234.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-16-2013, 10:08 AM
redzan redzan is offline Sorting a mail merge by a specific number in the document Windows 7 32bit Sorting a mail merge by a specific number in the document Office 2003
Advanced Beginner
Sorting a mail merge by a specific number in the document
 
Join Date: Feb 2012
Posts: 37
redzan is on a distinguished road
Default

Can this sort be done after the fields have been merged in? I manually enter that number on each letter. It does not populate from the merge.

Maybe I need to go about this in a different way?
Reply With Quote
  #4  
Old 05-16-2013, 02:57 PM
macropod's Avatar
macropod macropod is offline Sorting a mail merge by a specific number in the document Windows 7 32bit Sorting a mail merge by a specific number in the document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I have no idea what you mean by "Can this sort be done after the fields have been merged in?". You specify the sort order in the mailmerge main document before executing the merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-17-2013, 09:04 AM
redzan redzan is offline Sorting a mail merge by a specific number in the document Windows 7 32bit Sorting a mail merge by a specific number in the document Office 2003
Advanced Beginner
Sorting a mail merge by a specific number in the document
 
Join Date: Feb 2012
Posts: 37
redzan is on a distinguished road
Default

Sorry that was confusing but I understand now. Thanks for your help!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting a mail merge by a specific number in the document Mail Merge to create specific number of table rows flackend Mail Merge 4 12-01-2023 02:49 PM
Sorting a mail merge by a specific number in the document Mail Merge a Listing grouped by specific field KarenLS Mail Merge 1 11-11-2012 02:41 PM
Sorting a mail merge by a specific number in the document how do i ad a specific pdf file to a mail merge? mseibel Mail Merge 1 08-28-2012 07:53 PM
Sorting a mail merge by a specific number in the document specific mail merge cmccabe Mail Merge 3 06-14-2012 04:12 PM
Sorting a mail merge by a specific number in the document Mail Merge to print specific record based on mergefield criterias nicnad Mail Merge 1 02-22-2012 01:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft