vaRecipient = multiple names
 

Have this code that sends worksheet via lotus notes....

Tried placing a comma, semicolon, and every other trick i could think
of but cant get it to work.
Need to add more than one name.


vaRecipient = "jeremy aldridge"


thanx

vaRecipient = multiple names
 

I don't use Lotus Notes, but I'd try:

vaRecipient = array("jeremy aldridge", "next name here", "another")

vaRecipient is declared as a Variant, right???

"J.W. Aldridge" wrote:

Have this code that sends worksheet via lotus notes....

Tried placing a comma, semicolon, and every other trick i could think
of but cant get it to work.
Need to add more than one name.

vaRecipient = "jeremy aldridge"

thanx

--

Dave Peterson

vaRecipient = multiple names
 

For the OP

See Dennis his site for Notes code
http://www.excelkb.com/?cNode=1X5M7A

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
I don't use Lotus Notes, but I'd try:

vaRecipient = array("jeremy aldridge", "next name here", "another")

vaRecipient is declared as a Variant, right???

"J.W. Aldridge" wrote:

Have this code that sends worksheet via lotus notes....

Tried placing a comma, semicolon, and every other trick i could think
of but cant get it to work.
Need to add more than one name.

vaRecipient = "jeremy aldridge"

thanx

--

Dave Peterson

vaRecipient = multiple names
 

Dave,

yes, it is declared as a variant.

However, still got an error...... "runtime error 13, type mismatch"

this line was highlighted.


Loop While vaRecipient = ""