Email Module

[Guest]

What I would like to do is create a module or macro button to my form that
when I have finished inputting all my data; I hit the button and an email is
generated through my Thunderbird Mail Server. The email will consist of a
report that is generated from a query. The query consists of the columns
that I want to include in the email with the criteria that it must have
today's date [Date = Date()]. I have gotten the query and the report the way
I want them. I just can't seem to figure out how to generate the email
directly from the form.
I tried creating the button from the command button choices and it returned
the error, "Module not found".
Any help would be greatly appreciated.

 

[Scott McDaniel]

What I would like to do is create a module or macro button to my form that
when I have finished inputting all my data; I hit the button and an email is
generated through my Thunderbird Mail Server. The email will consist of a
report that is generated from a query. The query consists of the columns
that I want to include in the email with the criteria that it must have
today's date [Date = Date()]. I have gotten the query and the report the way
I want them. I just can't seem to figure out how to generate the email
directly from the form.

You can use DoCmd.SendObject to send an email via your default email handler ... I assume this would work with
Thunderbird, but have never tried it. If Thunderbird can be automated, then you could do that also (you'd need to
contact the developers or a support group/site for info on that). Be aware that you cannot send an attachment using
SendObject - you'd need to either embed the report in the body of the email (and lose any formatting, grouping, etc) or
send it as a SnapShot.

For info on DoCmd.SendObject, check online help ...

I tried creating the button from the command button choices and it returned
the error, "Module not found".
Any help would be greatly appreciated.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Guest]

Thanks for the help. But I'm still getting the error "Module not found" not
matter what I do. What am I doing wrong?

What I would like to do is create a module or macro button to my form that
when I have finished inputting all my data; I hit the button and an email is
generated through my Thunderbird Mail Server. The email will consist of a
report that is generated from a query. The query consists of the columns
that I want to include in the email with the criteria that it must have
today's date [Date = Date()]. I have gotten the query and the report the way
I want them. I just can't seem to figure out how to generate the email
directly from the form.

You can use DoCmd.SendObject to send an email via your default email handler ... I assume this would work with
Thunderbird, but have never tried it. If Thunderbird can be automated, then you could do that also (you'd need to
contact the developers or a support group/site for info on that). Be aware that you cannot send an attachment using
SendObject - you'd need to either embed the report in the body of the email (and lose any formatting, grouping, etc) or
send it as a SnapShot.

For info on DoCmd.SendObject, check online help ...

I tried creating the button from the command button choices and it returned
the error, "Module not found".
Any help would be greatly appreciated.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Scott McDaniel]

Thanks for the help. But I'm still getting the error "Module not found" not
matter what I do. What am I doing wrong?

Can you post the code behind the command button that is throwing the "Module Not Found" error?

What I would like to do is create a module or macro button to my form that
when I have finished inputting all my data; I hit the button and an email is
generated through my Thunderbird Mail Server. The email will consist of a
report that is generated from a query. The query consists of the columns
that I want to include in the email with the criteria that it must have
today's date [Date = Date()]. I have gotten the query and the report the way
I want them. I just can't seem to figure out how to generate the email
directly from the form.

You can use DoCmd.SendObject to send an email via your default email handler ... I assume this would work with
Thunderbird, but have never tried it. If Thunderbird can be automated, then you could do that also (you'd need to
contact the developers or a support group/site for info on that). Be aware that you cannot send an attachment using
SendObject - you'd need to either embed the report in the body of the email (and lose any formatting, grouping, etc) or
send it as a SnapShot.

For info on DoCmd.SendObject, check online help ...

I tried creating the button from the command button choices and it returned
the error, "Module not found".
Any help would be greatly appreciated.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Guest]

I managed to get it to work. Thanks for your help.

Thanks for the help. But I'm still getting the error "Module not found" not
matter what I do. What am I doing wrong?

Can you post the code behind the command button that is throwing the "Module Not Found" error?

What I would like to do is create a module or macro button to my form that
when I have finished inputting all my data; I hit the button and an email is
generated through my Thunderbird Mail Server. The email will consist of a
report that is generated from a query. The query consists of the columns
that I want to include in the email with the criteria that it must have
today's date [Date = Date()]. I have gotten the query and the report the way
I want them. I just can't seem to figure out how to generate the email
directly from the form.

You can use DoCmd.SendObject to send an email via your default email handler ... I assume this would work with
Thunderbird, but have never tried it. If Thunderbird can be automated, then you could do that also (you'd need to
contact the developers or a support group/site for info on that). Be aware that you cannot send an attachment using
SendObject - you'd need to either embed the report in the body of the email (and lose any formatting, grouping, etc) or
send it as a SnapShot.

For info on DoCmd.SendObject, check online help ...


I tried creating the button from the command button choices and it returned
the error, "Module not found".
Any help would be greatly appreciated.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com