M
mtreske
Guest
Hi,
Trying my post again, didn't realize I cannot attach a .rtf file.
I Have an access database on Windows2000 server, that contols user access to our website. Until a server failure a month or so ago, when a new user was assigned or his profile updated it would send a reply out via Outlook.
I don't know enough about VB to see if there is a problem with the code or if there is another issue at work, ie: Frontpage extensions, or some other server issue. As the code is quite lenghly I an sending just the "If MsgBox" code. I can send more information if needed. For now if someone can take a look at the below code and let me know if it should work ok, I'd appreciate it.
Thank you.
If MsgBox("Would you like to e-mail a confirmation to the user?", vbYesNo, "E-mail") = vbYes Then
DoCmd.SendObject , , acFormatTXT, "'" & [Forms]![webPW]![textEmail] & "'", , , "CMS Web Access", strmsg + strmsg2 + strmsg3 + strmsg4 + strmsg6 + strmsg7 + strmsg8 + strmsg9 + strmsg10 + strmsg11, False
Else
End If
Trying my post again, didn't realize I cannot attach a .rtf file.
I Have an access database on Windows2000 server, that contols user access to our website. Until a server failure a month or so ago, when a new user was assigned or his profile updated it would send a reply out via Outlook.
I don't know enough about VB to see if there is a problem with the code or if there is another issue at work, ie: Frontpage extensions, or some other server issue. As the code is quite lenghly I an sending just the "If MsgBox" code. I can send more information if needed. For now if someone can take a look at the below code and let me know if it should work ok, I'd appreciate it.
Thank you.
If MsgBox("Would you like to e-mail a confirmation to the user?", vbYesNo, "E-mail") = vbYes Then
DoCmd.SendObject , , acFormatTXT, "'" & [Forms]![webPW]![textEmail] & "'", , , "CMS Web Access", strmsg + strmsg2 + strmsg3 + strmsg4 + strmsg6 + strmsg7 + strmsg8 + strmsg9 + strmsg10 + strmsg11, False
Else
End If