14. april 2010 - 08:46
Der er
18 kommentarer og 1 løsning
Sned obejct
Hej Jeg har en knap, som ved aktivering skal sende 3 x rapporter til flere modtagere. Eks rapport1 og rapport2 og rapport3. Ved at klikke på knappen aktiveres makro, som sender de 3 rapporter som .txt fil. Hvordan kan jeg lave en makro, der sender flere rapporter på en gang ? MVH Tony
Annonceindlæg tema
Cloud & AI
Teknologi, AI og forretning er i centrum på Computerworlds Cloud og AI Festival i København d. 18. og 19. september. Se hele programmet for den store konference om strategisk brug af Cloud og AI på: www.cloud-festival.dk
14. april 2010 - 09:07
#2
Hi Terry Cannot use outlook, there are many users using the same login, so outlook is not used on this computer. Regards Tony
14. april 2010 - 09:21
#3
I dont think you can attach more than one report at a time using Send Object :o(
14. april 2010 - 09:33
#4
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!
14. april 2010 - 09:34
#5
I thinkyou will need to look at the link "Directly via the Winsock"
26. april 2010 - 08:39
#6
status please ?
26. april 2010 - 10:56
#7
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
26. april 2010 - 11:23
#8
"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
27. april 2010 - 08:21
#9
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
27. april 2010 - 11:47
#10
"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
28. april 2010 - 08:51
#12
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
28. april 2010 - 20:29
#13
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
Hi Terry Yes you are right. Sorry.
have ýou tried the idea at #5?
10. august 2010 - 17:12
#19
Løsning: At samle rapporterne til en rapport og derefter bruge send obect. Tak for hjælpen
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser