send emails with attachments

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

Hi everyone,
I'm stuck trying to attach files to some emails I need to send to my
clients.

I'm using Access 2003 and Outlook 2003. Using a recordset and a form,
I've been able to send e-mails with subject, remarks, cc, but what I
can't seem to do is to attach a file to the e-mail.

I'm using:
Set AttachmentPath = Forms!MAIL![Attachment]

'Add the attachment to the e-mail message.
If Not IsMissing(AttachmentPath) Then
Set objOutlookAttach = .Attachments.Add(AttachmentPath)
End If

Again and again I've tested it and it sends the e-mail to all my test
addresses but without the attached file.
Could anyone please tell me what am I doing incorrect?
Thanks in advance for your help.
 
Did you see my response to your other post on this issue?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top