How can I attach a file

B

Box 666

From a form (Access 2000) I have a button that will send an email, it will
open first in an Outlook window to be checked and by pressing "send" off it
will go.
On some emails I need to attach an excel file, I can attach it at the
checking stage, but ideally I would like Access to do it for me (say by
having the file location detailed on the form). What is the best way to do
this.. I am not a programmer, but I just try to add small bits of code when
needed.

I have detailed below the code to send the email, incase it can be amended
re the file attachment (I know its not pretty but it works)


DoCmd.SendObject , "", "", Forms![All Unread]![Send Reply to], Forms![All
Unread]![Copy Reply to] & "", "", Forms![All Unread]![Heading Reply],
Forms![All Unread]!Reply & vbCrLf & vbCrLf & vbCrLf & Forms![All
Unread]!signature & vbCrLf & vbCrLf & "Original Emails" & vbCrLf & vbCrLf &
Forms![All Unread]!Contents, True, ""


with thanks

Bob
 

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

Unreadable text when viewing organization chart in Web version of Visio 365 1
How to display the merge function "url" of a picture? 0
Email Coding works in one form but not the other... 2
DoCmd.SendObject in AC2007 3
Setting up and synchronizing Outlook calendars on iPhone 0
Sharepoint not capturing staff name when automation runs 0
Print A For (docm), Send Email Attachment And Close For Without Saving 2
How to insert Certificated digital signature in Word for Mac 0

Top