E-Mailing with attachments with Outlook Express

  • Thread starter Thread starter Guest
  • Start date Start date
I'm sorry, my question was rather vague. I meant to ask how to programmably
e-mail from MS Access when the user uses Outlook Express instead of outlook.
I use automation in other programs with Outlook but my client only uses
express. I now use the sendobject for just e-mails in his program but I
don't see how I can attach a rtf or xls file to it and send it. Is it
possible to use the CDO 1.21 library? Any other libraries I can use? If
there's not a good way then I will just have him set up Outlook accounts for
his employees.
 
If your attachment can be in Excel format, there are a few
ways you can send an XLS file from Access using the default
eMail program

'~~~~~~~~~~~~~

Here is a link to a simple method using

Application.Dialogs(xlDialogSendMail).Show

http://book.itzero.com/read/others/...Edition.eBook-LiB_html/8218final/LiB0088.html

from Access, you would define an Excel Application object
and use that reference instead of "Application"

ie:

xlApp.Dialogs(xlDialogSendMail).Show

'~~~~~~~~~~~~~

You can also use Access to issue the SendMail to Excel --
here is an Excel example (and you would just preface the
statements with the appropriate Excel object variable)

SendMail has 3 parameters:

1. recipient's address
2. subject
3. optionally, True or False for recipient confirmation (if
recipient's system can do this)

ThisWorkbook.SendMail _
"(e-mail address removed)", _
"Attached Workbook"




Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
Yes the CDO 1.21 library works very nicely with Access and attachments. Make
sure that the smtp service is running and that a reference is set to the CDO
1.21 Library and if using an Exchange Mail Server you'll need CDOEX.DLL.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top