Hi, I am using the SendObject function to send an email automatically from a form. However, the email address is generated from a field on the form. The email is always sent but quite often, an illegal operation occurs, showing the following details. Any ideas please?
MSACCESS caused an...
I have found a new fault. Whenever i try to change the name (Currently OptionalSubject), an illegal operation occurs again when the procedure runs.
DoCmd.SendObject , , , "bukhix@mydomain.com", , , "OptionalSubject", _
FullText, True
Just found out that it works when i put the following in:
Dim vbCrLf As String
However, then the text in the message it produces just blends together, anyway of left aligning it?
Thanks, I have added the extra line but it still performs illegal operations. Any more ideas? Also, is there anyway of being able to select the email address from a list in the database and be able to send it straight away without it opening for me to send or close it?
Hi, I have used the following code in a database. It opens an email fine but when I try and send it or close it, Access performs an illegal operation. Any ideas please?
Open "c:\TestFile.txt" For Input As #1
Do While Not EOF(1)
Line Input #1, strText
if FullText<>"" then FullText=FullText &...
Hi, I have used the same code for one of my databases. The email message opens fine but when i try and send it or close it, Access performs an illegal operation. Any ideas please?