Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-19-2018, 01:27 PM
indieben indieben is offline Automating Updates For Advanced Filtering Into New Sheet Windows 10 Automating Updates For Advanced Filtering Into New Sheet Office 2016
Novice
Automating Updates For Advanced Filtering Into New Sheet
 
Join Date: Jul 2018
Posts: 6
indieben is on a distinguished road
Default

Hi nosparks,

I've got around to attempting to do a mail merge based on the Unregistered filter - the following is the list of sources available (Screenshot):



https://snag.gy/ajLFSi.jpg


The only "Unregistered" option that has address fields available is the "unregistered extract", however, when I attempt to run the mailmerge, none of the addresses are available and the following error appears:

"Word could not merge the main document with the data source because the data records were empty or no data records matched your query options".

I have hidden the "Eligibility" and "registered"/ "unregistered" fields that appear on each of the filtered sheets.

Any help would be gratefully received.

Thanks ever so much

Kind Regards,

indieben.
Reply With Quote
Reply

Tags
advanced filters, excel 2016, macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating Updates For Advanced Filtering Into New Sheet Finding Capital Letters and filtering them out in an excel sheet ch1325 Excel 4 08-20-2015 07:25 AM
Automating Updates For Advanced Filtering Into New Sheet Filtering (advanced?) in Pivot Table canajun Excel 6 01-17-2015 05:01 AM
Need help in automating data from multiple sheets into a single sheet veedee Excel Programming 8 06-12-2014 10:04 PM
Automating Updates For Advanced Filtering Into New Sheet Need help in automating data from multiple sheets into a single sheet veedee Excel 1 06-11-2014 04:01 AM
Automating document updates with new text wordfoolish2 Word 0 01-04-2011 01:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 PM.


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