#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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.
|
#4
|
|||
|
|||
Ah this function exists within mail merge
|
#5
|
||||
|
||||
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] |
|
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 |
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 |
Mailing labels | weamish | Mail Merge | 11 | 12-16-2011 05:18 AM |