[mso] Re: Email from Outlook using list in Excel
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 20 Aug 2002 18:45:43 -0500
FYI...I attempted to send this message right away, but I guess I used
the sub - scrib - er word and it got stuck cos' I got a message that it
was being held!
So let me try this again...
Ya know...I'm SURE there's a techno geek way to do this, but I'll tell
ya, I send out my TechTrax reminder email each month, to now nearly 600
readers and I do it the easy old way.
I have all the data in an Access DB, collected from the web. After
downloading the most recent list...once a month I click the button in
Access to send all the into to Excel. Then I select the email column in
Excel, copy and paste the info into Word and then run a quick macro that
turns the resulting table and converts it into text (Table/Convert Table
to Text). Then the macro removes all the paragraph markers (^p) and
replace it with ; for the email. I end up with a mass of emails which I
easily copy/paste into the BCC field of the email.
I know it's not the classy way to do it, but who needs fancy code when
it works so easy with a couple quick copy/pastes. The whole process
takes about 30 seconds. Granted, manually (without the macro), it might
take 60 seconds. But this is one email to 600 people. If you wanted
individual emails to each, you'd have to do something a little more
automated.
Good luck!
Dian Chapman
Technical Consultant, Instructor,
Microsoft MVP & TechTrax Editor
Word AutoForm/VBA eBook: http://www.mousetrax.com/books.html
Tutorial web site: http://www.mousetrax.com/techpage.html
TechTrax Ezine: http://www.mousetrax.com/techtrax/
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Peter Strisik
Sent: Tuesday, August 20, 2002 6:06 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Email from Outlook using list in Excel
Peg,
You don't say which versions you are using. I tried using Excel and
Outlook 2002. Select the cells in the Excel column and copy to
clipboard. Open a new message in Outlook and paste into the To: field.
It pastes each address on one row. Click out of the To: field and the
addresses will format onto one row. Delete the remaining blank rows.
I tested with only three addresses. I don't know what'll happen if you
try this with 50. Also, I suppose you can paste into the CC or BCC
fields similarly.
........Peter
> I'm sure I've seen this question before, and I apologize. I'm
> having trouble finding an answer in the archive. Is there a
> way I can send a email to a list of email addresses stored in
> a column in Excel (or Access)?
>
> Thanks in Advance!
>
> Peg Wier
> TRAX Training & Documentation Specialist
> pjmwier@xxxxxxxxxx
> SSOF/SCHL
> 67691/63623
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
