How can I combine 3 separate mailing list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with 3 separate mailing lists stored in 3 excel workbooks. I
want to keep separate files, but occasionally need to combine all three into
one file or workbook to do a large mailing. Do I have to create a fourth
workbook and copy and paste the three existing files to create one large
file? Or, is there an easier way?

At the moment, I'm unable to take the excel online tutorial because I am
currently working on a machine at home that has an older version of excel.
However, the excel files I'm trying to combine are on my machine at work that
has windows xp professional. I can access the tutorial fine when I'm at
work, but not on my home machine for the reasons stated.

Can someone provide some guidance, please? Thank you.
 
Hi

my first question would by why do you want to keep them separate ... if you
use an additional column in each list to indicate whether it belongs to list
1 or 2 or 3 you can filter by this field when you need them separate and
ignore it when you want them combined. This IMHO would be the easiest way
to deal with your situation.

Cheers
JulieD
 
I never thought of that! I can see your point... adding another field to
identify each list is simple enough to do. Even I can do that. However, I'm
already starting out with 3 existing lists. I still need to know what is the
easiest way to combine them?

Thanks for your input.

Mary Lou
 
Hi

personally, i would do a straight copy & paste ... probably into a fourth
if you open one to copy (add the extra column in here), click in a cell and
do control & shift & * it will select the used area - copy & paste into the
fourth ... repeat two more times

Cheers
JulieD
 
Back
Top