Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-01-2016, 11:33 AM
Red17 Red17 is offline Try to sort mailing lists Windows 10 Try to sort mailing lists Office 2013
Novice
Try to sort mailing lists
 
Join Date: Nov 2016
Posts: 3
Red17 is on a distinguished road
Default Try to sort mailing lists

We have several mailing lists, that do not share the same people. What I would like to accomplish is have a master spreadsheet where once we enter a persons name/info it updates automatically on which ever mailing list they are on. The only solution I know to implement would be the IMPORTRANGE function. However if I were to add or remove cells this would cause more trouble than it;s worth and we have over 400 contacts. Any way to attach a formula to a name(Ie Edward Smith) then have the rest of the row copy info from the master sheet? Sorry I am novice at this
Reply With Quote
  #2  
Old 11-02-2016, 06:48 PM
macropod's Avatar
macropod macropod is online now Try to sort mailing lists Windows 7 64bit Try to sort mailing lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Quote:
Originally Posted by Red17 View Post
We have several mailing lists, that do not share the same people.
In that case, what is the point of having sub-sheets if all the data will be on a master sheet? Surely a column on the master sheet could be used to indicate which mailing list each person is on, then filter by that column for mailing purposes.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-03-2016, 05:27 AM
Red17 Red17 is offline Try to sort mailing lists Windows 10 Try to sort mailing lists Office 2013
Novice
Try to sort mailing lists
 
Join Date: Nov 2016
Posts: 3
Red17 is on a distinguished road
Default

That is deceptively easy...... Is their a way to print off the data I've used as a csv? The main point is to use the address list for the mail merge function.
Reply With Quote
  #4  
Old 11-03-2016, 05:28 AM
Red17 Red17 is offline Try to sort mailing lists Windows 10 Try to sort mailing lists Office 2013
Novice
Try to sort mailing lists
 
Join Date: Nov 2016
Posts: 3
Red17 is on a distinguished road
Default

Ah this function exists within mail merge
Reply With Quote
  #5  
Old 11-03-2016, 12:30 PM
macropod's Avatar
macropod macropod is online now Try to sort mailing lists Windows 7 64bit Try to sort mailing lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

There is no need for the csv - you can use Word's mailmerge, which includes the necessary filtering tools, directly with the Excel data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating global contact lists (distribution lists) Outlook 2011 Mac pengyou Outlook 0 09-10-2016 02:18 PM
Try to sort mailing lists I want to create a lists within lists (nested merges) AndyS Mail Merge 10 12-11-2015 03:05 PM
Mailing via access habiler Word 0 03-06-2015 09:46 AM
Automated E Mailing gobby Outlook 2 05-21-2014 12:23 AM
Try to sort mailing lists Mailing labels weamish Mail Merge 11 12-16-2011 05:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:58 AM.


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