VBA explicitly setting name and address in dist lists?

  • Thread starter Thread starter Dan Zerkle
  • Start date Start date
D

Dan Zerkle

I've got a list of names and e-mail addresses in an
Excel worksheet. I want to export them to an Outlook
(2002) distribution list.

I've figured out how to create the distribution list and
the kludge with a temporary e-mail message object to
create the recipients list.

I haven't figured out how to enter a separate e-mail
address and real name for each user. Setting up
recipients seems to want to have one string, which then
gets resolved automatically. I don't want that. I
already have separate names and e-mail addresses.

Let me emphasize: Some of my name/address pairs are NOT
in any Outlook address book, and will NOT resolve. The VB
code must set both the name and the e-mail address
explicitly.

The "Name" field of the Recipient object got me excited
for a few moments, but it's read-only.

What's the trick, here?
 
Back
Top