HELP VB for Access 2007 to email Excel attachemnet via Lotus Notes

[rpeare]

multiple emails should be as simple as:



maildoc.sendto = ("email1@email.com, email2@email.com, etc..")

for outlook a comma or semi colon are equally valid separators I suspect the same is true of lotus notes.

[nagiese]

When I enter the array in with the multiple email addresses I get a mail router delivery failure. Lotus notes is not picking up the second email address, its reading the email.com email2 as an address. when you look at the format that is comming through it looks normal but for some reason its not processing through accurately. I'm not sure why. Right now I'm only able to Sendto, CC, and BCC some one. I'm not sure how I'm going to make this work if I have to send a report out to a distribution list.

[rpeare]

Try messing around with something like

dim tostring
tostring = "email1@email.com, email2@email.com"
maildoc.sendto(tostring)

or mess around with the punctuation

tostring = "email1@email.com; email2@email.com"

[nagiese]

No such luck got same router delivery failure.

[rpeare]

perhaps this:

maildoc.sendto("email1@email.com","email2@email.co m")