Trouble using GetAddress method
I'm using the GetAddress method to retrieve Contact info from Outlook (using VBA in Word.) If I work with one Contact at a time, I have no trouble. If I display the dialog box to use To: and CC: fields, I run into problems.
The value of sAddress is:
sAdddress = Application.GetAddress("", , _
UseAutoText:=False, DisplaySelectDialog:=1, SelectDialog:=2)
Robert Alexander, Esq., Dr. David Sutton
Anthony Adami, Jr., John Kamp
That's two To: Contacts and two CC: contacts. The To: and CC: contacts are separate by vbCrLf; Contacts are separated by a comma. But, as you can see above, there are commas in the Contact names, so I can't Split the line with a comma as my delimiter.
Is there any other way to retrieve the selected names so that I can then pass the individual names back to GetAddress to get the Contact info (company, address, etc.)?