Connecting Tech Pros Worldwide Forums | Help | Site Map

Emailing Reports in the body and adding attachments

mike11d11
Guest
 
Posts: n/a
#1: May 15 '06
I'm having a problem trying to add attachments to my email from my C:\
drive. What I'm trying to do here is have my database run a bunch of
queries that gives me a report that I'm putting in the body of my email
message as HTML format using a macro Sendobject. But this doesn't
allow me to add any attachments from my machine. I'm positive this
could be done through VBA code but I know very little on the
programming side. could someone show me a very simple same code that
would put a report from my database in as the body of an email and then
go grab two attachments off my C:\ and add it to the email also. I've
noticed you have to have stuff refrenced in your Code in order to have
the database understand it, so if you could let me know what it is that
you are referencing or what I would need to do. I appreciate any help!!

pietlinden@hotmail.com
Guest
 
Posts: n/a
#2: May 17 '06

re: Emailing Reports in the body and adding attachments


you can't do this with SendObject, you have to automate your e-mail
client. Sorry, SendObject is only good for really simple e-mails...

Closed Thread