By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,880 Members | 2,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,880 IT Pros & Developers. It's quick & easy.

Emailing Reports in the body and adding attachments

P: n/a
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!!

May 15 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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...

May 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.