Sned obejct

I think you will need to use Outlook using VBA code

You can find an example here where you can attach files

http://www.eksperten.dk/spm/670613

Hi Terry

Cannot use outlook, there are many users using the same
login, so outlook is not used on this computer.


Regards

Tony

I dont think you can attach more than one report at a time using Send Object :o(

Heres a link http://www.granite.ab.ca/access/email.htm whith some example for sending reports etc.

One of them "demonstrate sending multiple reports to multiple recipients ".

I've had a very quick look at it but I cant see that it can send more than one report in the same email!

I thinkyou will need to look at the link "Directly via the Winsock"

status please ?

Hi Terry


Installed Outlook on the computer, now I will
try to use the program code you linked to.

But because there are many users, i dont want to save the report on the hardrive first.

It should open the report automaticly, and the  attach it to the the email, is that possible ?

Tks, for your feed back.

Tony

"But because there are many users, i dont want to save the report on the hardrive first."

Why not? '
You can always delete them again once you have sent them

Hi Terry


Many users have to send the report 4 times a day.


I'am affraid to many mistakes, it hard to have diciplin,
with many users.  To many places where mistakes can happend.

The should be a button attached to a makro, to open and attach
the 3 reports, to an email. (no mistake will happend)

Regards

Tony

"To many places where mistakes can happend."

I agree, but if its all done in code then the users arent aware of this.

Access CAN NOT attach more than one file to a mail without using code. And to do this the reports will have to be saved to the HD

Hi Terry


Okay, can the code you linked to, open more than one report ?
(and how ?)

http://www.eksperten.dk/spm/670613


Regards

Tony

If you look at this part


vedhæftet.Add "C:\test.txt" '<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Your file goes here


you just need to add another line for each attachment


vedhæftet.Add "C:\test2.txt" '<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Your NEXT file goes here

Tks Terry


And it will automaticly save the files as Test1 and test2 ?


Regards


Tony

Hi Terry

My last question, will it automaticly save 2 files ?

You wrote in #10, it will all happpens in the code, the user will
not be aware, that the files are saved on the harddisk.


Regards

Tony

You need to use DoCmd.OutPutTo ... to save the reports first

http://www.blueclaw-db.com/docmd_outputto_example.htm

Tony you should also follow up on other questions you have going on otherwise users may no be happy to help you

F.eks:
http://www.eksperten.dk/spm/906998

Hi Terry


Yes you are right.


Sorry.

have ýou tried the idea at #5?

Løsning:


At samle rapporterne til en rapport og derefter bruge send obect.


Tak for hjælpen