D
Dave
ok. no answer to the query about the 255 character limit on control's
hyperlinkaddress property... it does seem to be that way, no way i have
found around it...
so what are other possibilities for generating email from vba in access?? i
have no control over mail clients nor mail servers used. i can not even
expect the machines to have ms office. so how would you generate emails in
a very general fashion from vba?
some ideas i have had include putting in the ie control and feeding it the
mailto: link, does that avoid the 255 character limit??
where i have done this before and had control of an smtp server i have put
in my own smtp client, but this case i can't count on that type of access...
should i reconsider this maybe? these will all be home users with unknown
isp's and skill levels, should they be expected to be able to configure the
smtp server info? is this even possible with isp security restrictions??
how about a mail merge type operation? is that possible from non ms
clients? could i write a csv file with addresses and a couple fields to
merge and expect a home user to be able to merge that with a message
template to send mail easily??
or is the imap interface general enough to use with various clients? i
haven't looked at that much because it appears to want to connect to the
mail server which i would rather stay away from if possible. or is there
some other message generating interface that is generic enough to use??
hyperlinkaddress property... it does seem to be that way, no way i have
found around it...
so what are other possibilities for generating email from vba in access?? i
have no control over mail clients nor mail servers used. i can not even
expect the machines to have ms office. so how would you generate emails in
a very general fashion from vba?
some ideas i have had include putting in the ie control and feeding it the
mailto: link, does that avoid the 255 character limit??
where i have done this before and had control of an smtp server i have put
in my own smtp client, but this case i can't count on that type of access...
should i reconsider this maybe? these will all be home users with unknown
isp's and skill levels, should they be expected to be able to configure the
smtp server info? is this even possible with isp security restrictions??
how about a mail merge type operation? is that possible from non ms
clients? could i write a csv file with addresses and a couple fields to
merge and expect a home user to be able to merge that with a message
template to send mail easily??
or is the imap interface general enough to use with various clients? i
haven't looked at that much because it appears to want to connect to the
mail server which i would rather stay away from if possible. or is there
some other message generating interface that is generic enough to use??