this simple question really.
i'm having hard time solve it.
background:
i'm trying email address using .getaddress
method of word.application object.
now, don't have problem if user selects single to
, cc
recipients.
problem occurs when multiple emails selected user.
example, user selects 2 email address , 1 group list.
rawrecip = application.getaddress(, "<pr_display_name>", , 1, 2, true) debug.print rawrecip
using above code produces:
smith, john, joe, jane, all-hq group
each address selected separated <comma><space>
.
problem surname
, givenname
separated same.
need display name of 3 address selected user.
split
function doesn't me anywhere since cannot find or generate unique delimiter separate 3 display name.
is there clean way want?
smith, john joe, jane all-hq group
unbelievable. answer in front of me.
posting answer in case needs it.
need add character in getaddress
method.
edit:using space character gives best result
rawrecip = application.getaddress(, "<pr_display_name>" & " ", , 1, 2, true)
it produce:
smith, john , joe, jane , all-hq group
then can use split
function , text manipulation desired result.
dim integer, dname dname = split(rawrecip, " , ") = lbound(dname) ubound(dname) debug.print dname(i) next
and result:
smith, john joe, jane all-hq group
note:with space on last entry
Comments
Post a Comment