Emailing forms/Excel

  • Thread starter Thread starter jwrnana
  • Start date Start date
J

jwrnana

Is it possible to create a form from a query, and then send it to Excel in
order to email it to someone?

I have sent a report to excel, but when it prints, there are no lines.

When I send the form to a mail recipient, it does not send properly.

Your assistance -- I need to create a form from a query, and then forward on
to another individual who may, or may not have access on their computer, but
does have excel.

How do I do this.

Thank you, Joy Rose
 
Joy,

First we need to establish that you are actually wanting
to send a report and not a form? If this is correct there
are a couple of options if they do not have Access on
there machine. You can send it to excel as you stated.
Or you can use Adobe Acrobat and create a pdf. If you
have that software available. Or you can simply export to
rich text, or just txt. Like you stated the lines will
not be available. The only option that i know to work
around this is to use another third party software like
Crystal Reports. Access is really limited in regards to
report generation in my opinion.

Hope this is some help,
Kevin
 
Joy,

You can use the following method, from within MSAccess to send by email the
result of a query in Excel format.


DoCmd.SendObject acSendQuery, "sQueryName", acFormatXLS, "sEmailName", , ,
"sTitle" _
' , "sMessage", True

Well, look up the documentation to find the appropriate format that applies
to what you want to do.

Regards,

Michel Carreau
 
Back
Top