Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old May 15th, 2006, 07:25 PM
mike11d11
Guest
 
Posts: n/a
Default Emailing Reports in the body and adding attachments

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!!

  #2  
Old May 17th, 2006, 02:45 AM
pietlinden@hotmail.com
Guest
 
Posts: n/a
Default 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...

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,338 network members.