By running the following code:
Private Sub Command22_Click()
Dim otk As Outlook.Application
Dim eml As Outlook.MailItem
Dim rs As ADODB.Recordset
Dim myAttachments As Outlook.Attachments
Set otk = CreateObject("Outlook.Application")
' Open your table and build your distribution list...
PHV
Yes I can add attachments manually
The following hard coded version executes fine. But when I refer to the same information from the table it doesn't work.
Private Sub Command22_Click()
Dim otk As Outlook.Application
Dim eml As Outlook.MailItem
Dim rs As ADODB.Recordset
Dim...
The field contains a string that is the full path and file name. it is found in the same table "studentdata1" that the other fields (Email,subject, and body) are found in. What I don't understand is why the other fields work flawlessly if I rem this line. Yet with this line in it hangs.
I...
I made the correct change this time and this is the result I recieved:
Run time error "436" Object doesn't support this property or method
In the debugger the entire line is highlighted.
I appreciate your help on this.
I have built this routine and everything works except for the attachment. Any suggestions?
Private Sub Command22_Click()
Dim otk As Outlook.Application
Dim eml As Outlook.MailItem
Dim rs As ADODB.Recordset
' Open your table and build your distribution list
Set rs =...
Newbie here
When I post the following code I get an error "Compile error User defined type not defined" with the first dim statement highlighted. What am I doing wrong?
Public Sub Command0_Click()
Dim otk As Outlook.Application
Dim eml As Outlook.MailItem
Dim rs As Recordset...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.