How can I combine 3 separate mailing list?
 

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

"Baylynx" wrote in message
...
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.

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

"JulieD" wrote:

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

"Baylynx" wrote in message
...
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

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

"Baylynx" wrote in message
...
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

"JulieD" wrote:

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

"Baylynx" wrote in message
...
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.