Did you see my response to your other post on this issue?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Liz" wrote in message ups.com...
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.