How to email an existing xls file from “My Documentsâ€

A

Adnan

Hi All,
I have searched and thought I found what I was looking for not really – I
want a command button created on a form that will email me an existing xls
file from “My Documents†something that would have the file attached and a
curtain text with subject and email address already on place (command button
that would bring the message on display mode autosend)

------------------------------------------------------------------------------------------------
To: [email protected]
Cc: [email protected]
Subject: Service Order
Attach: ServiceOrder.xls (attached file goes here)

Body:

Dear Customer,
Please fill out the attached above and send it to address on CC filed….
Balah balha… etc…



Thank you!
Me
 
A

Adnan

Joseph,
I appreciate you answer but I am sure this is the right place to post such a
question/inquiry. But I guess, I must have not been clear on what I was
looking for. What I needed and still need is to be able to email a attachment
from a Microsoft Office Access Form, I have found lots of related topics but
not this particular one. I have created a ms access database for customers,
and I want them to fill a few fields on the form then if there’s anything
else they can just click on a button which would open up outlook window with
an attachment uploaded and a text message on email body that would say
“Please fill out the attached above on this message†then he/she fills the
attached (and clicks send button of the outlook mail window).

Thank you,
Adnan :)
 
P

Pieter Wijnen

DoCmd.SendObject

HTH

Pieter

Adnan said:
Joseph,
I appreciate you answer but I am sure this is the right place to post such
a
question/inquiry. But I guess, I must have not been clear on what I was
looking for. What I needed and still need is to be able to email a
attachment
from a Microsoft Office Access Form, I have found lots of related topics
but
not this particular one. I have created a ms access database for
customers,
and I want them to fill a few fields on the form then if there's anything
else they can just click on a button which would open up outlook window
with
an attachment uploaded and a text message on email body that would say
"Please fill out the attached above on this message" then he/she fills the
attached (and clicks send button of the outlook mail window).

Thank you,
Adnan :)
Click to expand...
 
R

Ron2006

If you are using Outlook and
if the attachment is something other that what send object allows you
to send

you may want to look at automation. Here is an example of sending
email via outlook

====================================
Set o = CreateObject("Outlook.Application")

Set m = o.CreateItem(0)

m.To = "Paul Tucker" ' The distribution list name or email
address(s) goes here

' m.CC = ' email address for copy

' m.BCC = 'email address for Blind Copy

m.Subject = "SUPP Analysis Spreadsheet "

m.body = Chr(13) & Chr(13) & _
" Date: " & date & Chr(13) & _
Chr(13)

m.attachments.Add exportName ' point to the full address of
attachment here
' There can be multiple of the above

' m.display ' display shows email and the user has to press send button

m.send ' Send does it automatically with security from Outlook

Ron
 
A

Adnan

Ron,
Your reply is exactly what I was looking for, you read my mind and you are
definitely a LIFE SAVER – thank you for everything, and I thank the other,
too. God bless you all!
Adnan, Computer Science Student, Kosovo
 
G

good12find

Hey Ron,
This also looks to be what I am looking for.
However, I am not fliud in Access code.
I copied and pasted the code you included into my db and it errored out.
Can you please further explain this code and will this work in Access 97?
Thanks!!
Donovan
 
Top