Send email with report as an attachment. Microsoft Access / VBA Forums on Bytes. Then query, report, macro, and vba can all access the value. I've also done this directly as a report filter: (simple example) Simple code: This is in my cancel button, it resets a couple of the tempvars so that if the report is open directly it will.
Hi AllI was just wondering if it was possible to send a report as the email body. I am wanting to send an automatic email to multiple people which will be personalised with their names etc.Thank you allAKIf I am reading you correctly, in order to properly answer this we have to understand the differences in what is termed the body of an email and a standard access report which is usually sent as an RTF attachment rather than in the actual BODY of an email message.Unless MS add this as standard functionality in Access as an simple.
Click 'errr put me this actual report into the actual body please' similar to a simple copy paste of an embedded spreadsheet say. Then the short answer is.No. (Yes we can place a shortcut to the report in the email but it is not the same thing as I perceive you are asking because this links to the original mdb file)The SNAPSHOT format is an alternative method whereby you can embed (iconic in appearance) a very good image representation of your report and paste it to an email as an attachment. This is viewable using the snapshot viewer that comes with Microsoft Office. It works independant of Access and thus any recipient of the.SNP file does not need Access on their machine but does need to have snapshot viewer installed.If the specifics of your question is purely centred on the body section of an email then it has to be said that the body section of an email consists of selectable formats 'Plain text' or 'HTML' format or RTF (rich text format).Typically we usually type directly into the 'body' portion of an email message if we are using 'Outlook' shall we say and then select whether or not we wish to send that email in one of those formats. We then usually add attachments to the email message itself consisting of eternal files ie: xls spreadsheet files.doc word documents and so on.HTML looks prettier whereas plain text speaks for itself - plain, simple with less overhead and minimal by definition.Plain text is obvious enough.
You might know that you can output a report as an HTML file. So in considering this as a 'possibility' how does the body section represent itself as HTML when it is sent? The text we see as the normal visible text is actually formatted using HTML tags and markers 'behind the scenes' and when it is sent, to put it simply, goes out with those tags and markers. We see none of these tags ( neither would we want to given it looks like a jumbled up mess around your actual text message)Now if we were wanting to make a 'report' look as if it was in the BODY section of an email we would have to get that report representing itself textually speaking with HTML tags. But an Access Report.
Is an Access Report, ie an internal object mechanism of Access. It appears to us as such in an Access preview window and gives us the option to print it or save it as certain formats one of which is.
MS Access 2003: Filter report results using the OpenReport VBA commandThis MSAccess tutorial explains how to filter report results using the OpenReport VBA command in Access 2003 (with screenshots and step-by-step instructions).Question: In Microsoft Access 2003/XP/2000/97, I have a report and I would like to be able to filter the report results without hardcoding parameters in the Query Builder.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |