Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2020, 04:10 AM
chippy chippy is offline Mail Merge addresses not in order Mac OS X Mail Merge addresses not in order Office 2019
Novice
Mail Merge addresses not in order
 
Join Date: Jun 2020
Posts: 1
chippy is on a distinguished road
Default Mail Merge addresses not in order

Hi all,

I am performing my first mail merge and I have hit a problem.



I have my list in excel

I have my mail merge all set up and working no problem except for one.

My list is thousands long and I only want the merge to take the first 100 entries. It is taking 100 entries but from a list of thousands randomly, not the top 100 entries as sorted.

This is no good to me as I need to know which address have already been used in the future.

To Recap, when I ask it to do 100 mail merges I want it to take the first 100 entries not 100 random entries.

Hope this makes sense

Thanks
Reply With Quote
  #2  
Old 06-20-2020, 01:37 PM
Charles Kenyon Charles Kenyon is offline Mail Merge addresses not in order Windows 10 Mail Merge addresses not in order Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,082
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Where are you sorting? Excel or Word?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge addresses not in order Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge djrexy Mail Merge 1 05-20-2020 04:04 PM
Mail Merge addresses not in order Word Mail Merge Envelope Addresses with Multiple Conditions Pedro007 Mail Merge 2 11-19-2019 07:25 AM
Mail Merge records out of order ARS Mail Merge 3 10-18-2017 02:13 PM
Mail Merge addresses not in order Mail merge custom labels with double mention of addresses bng Mail Merge 6 05-30-2013 03:00 AM
Mail Merge addresses not in order How to get mail merge to preview all addresses on labels rec Mail Merge 1 04-29-2011 10:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:48 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