Two reports as attachment

[Ravi Kumar]

Hello all,
How can I send two reports as attachment at a time with the help of the button?

 

[theDBguy]

Hi. What is your email client?

 

[Ravi Kumar]

Hi. What is your email client?

Microsoft Outlook

 

[theDBguy]

Microsoft Outlook

In that case, you could use Outlook Automation and use the .Attachments.Add method.

 

[Ravi Kumar]

In that case, you could use Outlook Automation and use the .Attachments.Add method.

as I am learning this access recently ,
could u please elaborate the steps ??

 

[theDBguy]

as I am learning this access recently ,
could u please elaborate the steps ??

Take a look here.

 

[Ravi Kumar]

Take a look here.

hello sir ,
I have attached my database , after copying the code & making necessary changes and clicking send report button in my "ot details report" , it is not working.
could u pls tell me where I am wrong??

 

[theDBguy]

hello sir ,
I have attached my database , after copying the code & making necessary changes and clicking send report button in my "ot details report" , it is not working.
could u pls tell me where I am wrong??

Hi. I am currently on travel and won’t be able to download your file for a while. I will let you know as soon as I get a chance to look at it.

 

[Gasman]

Ravi,

You really need to start with the basics and some basic debugging.
Getting everyone to write/amend your code for you is not going to help you much.

I have just downloaded your db and it is not evident where you are emailing?

You have to tell people how to replicate your problem.
I cannot even find the word attach in any of the code. :banghead:

hello sir ,
I have attached my database , after copying the code & making necessary changes and clicking send report button in my "ot details report" , it is not working.
could u pls tell me where I am wrong??

 

[Ravi Kumar]

Ravi,

You really need to start with the basics and some basic debugging.
Getting everyone to write/amend your code for you is not going to help you much.

I have just downloaded your db and it is not evident where you are emailing?

You have to tell people how to replicate your problem.
I cannot even find the word attach in any of the code. :banghead:

ok i'll try for myself & will find the solution for this .
thanks for your time.
can u send a good guide or book related to access vba??so that I can learn .

 

[Gasman]

ok i'll try for myself & will find the solution for this .
thanks for your time.
can u send a good guide or book related to access vba??so that I can learn .

Well I tend to start with Google. What we did before that came along I cannot remember. I do have an Access 2007 for Dummies book, but rarely look at it after reading it like a novel.

Normally Google will give me something to start with.
Another user has just posted for something similar and I mentioned the Similar Threads links at the bottom of this page.

Where in the DB is the code you amended from the link DB posted?, as I mentioned I could not even find the word attach which I would have thought would be used in the code?

 

[Gasman]

Ravi,
I'm willing to try and help you with this query, but you need to give me something to work with.?

ok i'll try for myself & will find the solution for this .
thanks for your time.
can u send a good guide or book related to access vba??so that I can learn .

 

[Gasman]

That other user I mentioned found their solution here

https://docs.microsoft.com/en-us/previous-versions/office/developer/office-2003/aa159619(v=office.11)?redirectedfrom=MSDN

 

[Gasman]

Ravi,
You are not accepting PMs, so I have to post here.

Please do not take my post in your thread of attachments as a personal insult.
It is just that you really will not help yourself if everyone is prepared to write the code for you.

I am not that experienced, so cannot knock up code off the top of my head. I google for what I am looking for and then amend, and that way I have learnt more and more of Access.

Now when I want to do something, like email data, I look to see where I have done this previously, Copy the code and amend it. The beauty of this however, is that I *understand* the code, as I amended it in the first place.

HTH

 

[Ravi Kumar]

Ravi,
You are not accepting PMs, so I have to post here.

Please do not take my post in your thread of attachments as a personal insult.
It is just that you really will not help yourself if everyone is prepared to write the code for you.

I am not that experienced, so cannot knock up code off the top of my head. I google for what I am looking for and then amend, and that way I have learnt more and more of Access.

Now when I want to do something, like email data, I look to see where I have done this previously, Copy the code and amend it. The beauty of this however, is that I *understand* the code, as I amended it in the first place.

HTH

dear sir ,
I am very sorry I was not able see your messages as I was busy in office work, really I didn't took it as insult .
I also know that always sending databases to write the code is not usable in long time.
hence I have also started reading access vba book to increase my knowledge about the same.
I really appreciate your concern.
Thank you so much for everything again.