Hi All,

I have written a routine in Excel 97 that e-mails a spreadsheet
attachment to a recipient stored in the contacts folder. This works
fine if the recipient is a totally unique name. However, if the start
of the name occurs more than once, then an error is encountered
because Outlook does not know which person to send the e-mail to. The
contact names are not the same, it is only the start of the name that
is the same. ie. Fred Bloggs and Fred Bloggson.

From other postings I have seen that I can trap the error by using
.Resolve but I don't understand why it cannot recognise 2 different
names. I do want my users to have to choose a name from a list when
the name is already clearly a valid name.

Any help much appreciated.

Regards

Glyn Baker

Outlook is trying to resolve the unresolved recipient name and does
the same as it does in the UI when trying to resolve a non-unique
name. To avoid that you need to resolve all recipients before sending.
It's good practice anyway.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm

Thanks Ken,

But surely there is nothing to resolve? The 2 names are distinct. Just
because part of the name appears twice why cannot Outlook recognise
that? Does it just look at the first x characters?

Regards

Glyn Baker

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!