send emails with attachments

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.
 
S

Sue Mosher [MVP-Outlook]

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

send emails with attchments 6
Sending email from Access 2000 using Outlook express 6 2
Email Report as Attachment with Voting Buttons 2
Send Multiple attachments to email 2
problem in (Set objOutlookRecip = .Recipients.Add(TheAddress)) 0
VBA Code For Outlook Attachment 4
Uknown error on send attachment. 2
how send an access report besides a C:\attachment already included 5

Top