Solve : MS-Outlook Resolve Method Bug?

1.	Solve : MS-Outlook Resolve Method Bug?
Answer» I am creating a distribution list from a spreadsheet. I find that that I can ADD all of the recipients which are "known" to me except those for whom I have more than one email address. That is, '.Resolve' fails. Is there a way around this? If the names of the recipients are the same in the multiple listings try abbreviating the 1st name in one while leaving the full name in the other... But i have to ask...why would they need to recieve the mail in each mailbox anyways ? ?I don't have duplicate CONTACTS; I have some contacts which have more than one email address. Those are the ones for which "Resolve" fails. Quote from: patio on June 01, 2010, 06:55:59 AM If the names of the recipients are the same in the multiple listings try abbreviating the 1st name in one while leaving the full name in the other... But i have to ask...why would they need to recieve the mail in each mailbox anyways ? ? I must not understand the gist of your question. There are times when someone actually wants a letter sent to both of his addresses. Anyway, the object of my routine is to populate a new distribution list (from spreadsheet data) which, when done VIA VBA, requires a populated Recipient object. When I find a contact (in the spreadsheet) that I want to add to the newly forming dist. list "Resolve" fails if that contact has more than one email address.

Answer»

I am creating a distribution list from a spreadsheet.
I find that that I can ADD all of the recipients which are "known" to me except
those for whom I have more than one email address.
That is, '.Resolve' fails. Is there a way around this?
If the names of the recipients are the same in the multiple listings try abbreviating the 1st name in one while leaving the full name in the other...

But i have to ask...why would they need to recieve the mail in each mailbox anyways ? ?I don't have duplicate CONTACTS; I have some contacts which have more than one email address. Those are the ones for which "Resolve" fails. Quote from: patio on June 01, 2010, 06:55:59 AM

If the names of the recipients are the same in the multiple listings try abbreviating the 1st name in one while leaving the full name in the other...

But i have to ask...why would they need to recieve the mail in each mailbox anyways ? ?

I must not understand the gist of your question. There are times when someone actually wants a letter sent to both of his addresses. Anyway, the object of my routine is to populate a new distribution list (from spreadsheet data) which, when done VIA VBA, requires a populated Recipient object. When I find a contact (in the spreadsheet) that I want to add to the newly forming dist. list "Resolve" fails if that contact has more than one email address.

Solve : MS-Outlook Resolve Method Bug?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment