D
David R. Eaton
I have a command to send e-mail to staff when something changes on a
partcular field in the database.
My command is as follows... zmail represents a variable holding the e-mail
address
(note: I cannot cut and paste because the network is isolated, so if there
are obvious typo's it was my bad typing)
DoCmd.SendObject acSendNoObject, , acFormatTXT, zmail, , , "Blah Blah Blah
Subject", "Blah Blah Blah Message Body", True
My problem is that any address over 32 (maybe 33) character in length and
this fails. Under 32 characters works fine. Our address scheme is based on
last name, so people with short last names have no problems. The long last
names fail.
If I put quotes around the name, then it willaccept up to 36 characters in
the e-mail address, but fails at 37.
Is this a shortcoming of the API used to connect to Outlook?
Any ideas are greatly appreciated
David R. Eaton
(e-mail address removed)
partcular field in the database.
My command is as follows... zmail represents a variable holding the e-mail
address
(note: I cannot cut and paste because the network is isolated, so if there
are obvious typo's it was my bad typing)
DoCmd.SendObject acSendNoObject, , acFormatTXT, zmail, , , "Blah Blah Blah
Subject", "Blah Blah Blah Message Body", True
My problem is that any address over 32 (maybe 33) character in length and
this fails. Under 32 characters works fine. Our address scheme is based on
last name, so people with short last names have no problems. The long last
names fail.
If I put quotes around the name, then it willaccept up to 36 characters in
the e-mail address, but fails at 37.
Is this a shortcoming of the API used to connect to Outlook?
Any ideas are greatly appreciated
David R. Eaton
(e-mail address removed)