How can I sent a Report via Email with a *.mdb output format. Access gives me the option to send an email only as HTML (*.htm,*.Html), Rich Tex Format (*.rtf), Snapshop Format (*.snp), and Text Files (*.txt). Is there a way to add *.mdb format to the ‘Send Object As’ list?
Thank you in advance.
Plaguna
6 3764 NeoPa 32,556
Expert Mod 16PB
A report is not a database, so I'm confused that you would ask about sending one as an MDB. Perhaps this is why the option is not provided.
In direct answer to your question though, I don't believe you can add another item to the list without installing some software to do the job. I'm not even aware of any software that could be installed which might add to the list.
I see what you mean when you say “A report is not a database”. Of course, a report is an Object of a *.mbd file…. Now I got that.
Though, the idea is to email a report to some people at work who are not familiar with MS Access and they don’t have even the time to look for a report in a *.mdb file (busy people). They just want to access to a nice report as an attachment or a single file report, for instance: Excel
I spent a lot of time creating a nice and professional looking report for them to see it and perhaps for them to print it out every day. Now, if I email it to them as a *.rtf or as a*.txt format, the whole purpose of creating a good Access report is useless. I understand that an Access report is based on a table and/or a query and they are connected to each other. But, is there a way to send a report via email as it looks. Any ideas?
Thank you in advance
plaguna
I see what you mean when you say “A report is not a database”. Of course, a report is an Object of a *.mbd file…. Now I got that.
Though, the idea is to email a report to some people at work who are not familiar with MS Access and they don’t have even the time to look for a report in a *.mdb file (busy people). They just want to access to a nice report as an attachment or a single file report, for instance: Excel
I spent a lot of time creating a nice and professional looking report for them to see it and perhaps for them to print it out every day. Now, if I email it to them as a *.rtf or as a*.txt format, the whole purpose of creating a good Access report is useless. I understand that an Access report is based on a table and/or a query and they are connected to each other. But, is there a way to send a report via email as it looks. Any ideas?
Thank you in advance
plaguna
If you have the full version of MS Office installed, just use the office links in access to publish the report with word or excel. Then you can email them the word/excel document.
You could also download a program called cutepdf. This program installs as a printer driver. You print your report to the CutePDF printer and it gives you the ability to then save the output as a PDF document.
NeoPa 32,556
Expert Mod 16PB
Your needs as you express them, are probably best served by Don's last suggestion (PDF files).
Snapshots (with a freely distributable Snapshot Viewer program) is the MS recommended way, but there are so many situations where they simply don't work that a much more generic format (PDF) is recommended.
I really appreciate the suggestion. This is exactly what I was looking for. It takes a few more steps to do it but, Cutepdf works perfectly for me. Thank you very much for your help.
plaguna
NeoPa 32,556
Expert Mod 16PB
I use Acrobat myself at work, but i think I must get hold of this CutePDF product sometime and do some automated converting with it.
Anyway, glad you're sorted :)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Johnny Gee |
last post by:
Hi All
I have a macro that I use to send three reports every week to about 10
people by email via Lotus Notes.I use the "Send To" command to send the
reports out in Rich Text Format. I used RTF...
|
by: michi |
last post by:
Hi there....
Got here a tricky thing with my SMTP.
First I show you what works on my machine..
**This Works**
SmtpMail.SmtpServer = "mail.gmx.net" <-gmx is my mail
provider...
|
by: toufik |
last post by:
Hi,
I've a crystal reports Report, Is it possible to send it by email? how?
Thanks
|
by: Mike Charney |
last post by:
Is there a simple way to send SMTP email from Access VBA?
Mike
m charney at dunlap hospital dot org
|
by: Rajani |
last post by:
Hi friends,
I am sending mail from ASP program. My server is win 2k, IIS 5. SMTP
server is configured.
I am generating a report(purchase order) and the same sending as an email to
the...
|
by: rdemyan |
last post by:
My app creates a building report.
My users have requested that I provide functionality to e-mail these
"building reports" to building managers once a month.
So assuming that I have the...
|
by: Nanker |
last post by:
I would like to integrate Reporting Services reports into an existing
email messaging framework using .NET 1.1 (both to leverage the existing
framework and since the error reporting by Reporting...
|
by: dreamsoul620 via AccessMonster.com |
last post by:
Hi all! I'm trying to set up an email application for my database. I tried
linking to my Outlook address book, but when reading from the table, I
receive an error message saying I need to restart...
|
by: shil |
last post by:
Hi,
I'm using FW 2.0 to send an email with an attachment using
System.Net.Mail class. If I try to attach a file from my file system,
I could successfully send the eamil. But I need to generate a...
|
by: pixie |
last post by:
Hi. Access 2003. The database stores contract information. I have a query for each person that is responsible for contracts. The query checks to see if there are reports due either this week,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |