I too have a list of email addresses in one column and would like to insert
all addresses into one email for a mass mailing, is it possible to do without
copy and pasting each email address in one at a time?
I too have a list of email addresses in one column and would like to insert
all addresses into one email for a mass mailing, is it possible to do without
copy and pasting each email address in one at a time?
I'd use this.
Insert a new column to the right of the email address column.
I'm gonna use A for my email column and B for my new column.
Put this in B1:
=A1
put this in B2:
=B1&";"&A2
(Change the separator to what you need)
And drag down the column.
Copy that last cell and paste into your email to: field.
Lizizfree wrote:
>
> I too have a list of email addresses in one column and would like to insert
> all addresses into one email for a mass mailing, is it possible to do without
> copy and pasting each email address in one at a time?
--
Dave Peterson
Or just paste into Word. Highlgiht the table in Word, go to Table -> Convert
->
Table to Text, having it use whatever separator (comma or semicolon, etc.).
It will create a nice list easily copied into the email.
"Dave Peterson" wrote:
> I'd use this.
>
> Insert a new column to the right of the email address column.
>
> I'm gonna use A for my email column and B for my new column.
>
> Put this in B1:
> =A1
> put this in B2:
> =B1&";"&A2
> (Change the separator to what you need)
>
> And drag down the column.
>
> Copy that last cell and paste into your email to: field.
>
> Lizizfree wrote:
> >
> > I too have a list of email addresses in one column and would like to insert
> > all addresses into one email for a mass mailing, is it possible to do without
> > copy and pasting each email address in one at a time?
>
> --
>
> Dave Peterson
>
Thank you very much, I tried it and it worked great
"Dave Peterson" wrote:
> I'd use this.
>
> Insert a new column to the right of the email address column.
>
> I'm gonna use A for my email column and B for my new column.
>
> Put this in B1:
> =A1
> put this in B2:
> =B1&";"&A2
> (Change the separator to what you need)
>
> And drag down the column.
>
> Copy that last cell and paste into your email to: field.
>
> Lizizfree wrote:
> >
> > I too have a list of email addresses in one column and would like to insert
> > all addresses into one email for a mass mailing, is it possible to do without
> > copy and pasting each email address in one at a time?
>
> --
>
> Dave Peterson
>
I tried it but when I copy and paste the column that was converted into text
it still wouldn't paste all of the addresses, it would only paste the first
one in the line.
"Wiley" wrote:
> Or just paste into Word. Highlgiht the table in Word, go to Table -> Convert
> ->
> Table to Text, having it use whatever separator (comma or semicolon, etc.).
> It will create a nice list easily copied into the email.
>
> "Dave Peterson" wrote:
>
> > I'd use this.
> >
> > Insert a new column to the right of the email address column.
> >
> > I'm gonna use A for my email column and B for my new column.
> >
> > Put this in B1:
> > =A1
> > put this in B2:
> > =B1&";"&A2
> > (Change the separator to what you need)
> >
> > And drag down the column.
> >
> > Copy that last cell and paste into your email to: field.
> >
> > Lizizfree wrote:
> > >
> > > I too have a list of email addresses in one column and would like to insert
> > > all addresses into one email for a mass mailing, is it possible to do without
> > > copy and pasting each email address in one at a time?
> >
> > --
> >
> > Dave Peterson
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks