[mso] Re: Outlook Distribution List :VSMail MX3
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Thu, 12 Dec 2002 13:59:21 -0800
Parker,
It's not nearly as clean as with Outlook or Word, but you can do this in
VBA. I have done it with Access reports, I don't see why you couldn't do it
with an email. There are some interesting issues though. Like having to
use the CHR(*) for linefeeds, and the like.
James
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, December 12, 2002 1:33 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Outlook Distribution List :VSMail MX3
Good luck, Parker. As far as I know, the only way to do this is with a mail
merge.
But, you *could* create the email, save it as a template, then send that
template to each person individually...but, that would be even more involved
then the mail merge, I would think.
If it were me (since Outlook macros are way weird), I would create the
letter in Word and run the macro recorder in there, while you set up the
merge, then you could use THAT macro to do it. (since Outlook doesn't even
have a macro recorder).
But, you might luck out by going to Slipstick.com....they do have some
addins and macros for download...if anybody has this one, I would say it
would be them.
Good luck.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Renaud, Parker
Sent: Thursday, December 12, 2002 1:27 PM
To: Microsoft Office Group (E-mail)
Subject: [mso] Outlook Distribution List
When using a distribution list in Outlook 2000, the names of each member of
the distribution list shows up in the "To" box when the e-mail is received
unless you use the "BCC" box. Then none of the names show up in the "To"
box, but you have to put at least one e-mail address (real or made-up) in
the "To" box in order to send it. I know you can avoid that problem by using
the Word mail merge feature, but it is a fairly long, involved process and
we would like to avoid it.
What I would like, is to find a procedure, macro, or add-in for Outlook that
would let me select names from a list, create one e-mail, and have Outlook
send each individual selected an e-mail with only their e-mail address in
the "To" box. Does anyone know of a way to do this, or a product that will
allow Outlook to do this?
Parker Renaud
*************************************************************
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:
- » [mso] Re: Outlook Distribution List :VSMail MX3
