Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email distribution of Access Record
I have a database that was made years ago that stores business proposals.
What I would like to be able to do is send a copy of a particular proposal (database record) to someone else over email so they can view it. Obviously I can't send them an access database, so copying the database record to an excel sheet seems the logical way to go. As it turns out, this is looking impossible. If you export a table to excel, it outputs a database table that is not readable. I would like to design an excel form so that it is neat and organized for someone else to read. I tried to use Dget functions to return table entries to an excel sheet that is designed the way I would like my form to look. My problem is that when I am done, all I have is an excel sheet with a bunch of formulas. What I want is only the output of the formulas, and not the stupid formulas themselves for people to read. Once my form is sent to someone else, obviously it will not be connected to the database anymore, and so the forumlas will not be displaying results at all! It appears impossible to copy the results of these forumulas into a form so that I can email it to someone. Is there a way to resolve this problem, or is it impossible to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email distribution of Access Record
Hi,
You should post this to the Access newsgroup at: http://www.microsoft.com/communities...&lang=en&cr=US -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Snyderm" wrote: I have a database that was made years ago that stores business proposals. What I would like to be able to do is send a copy of a particular proposal (database record) to someone else over email so they can view it. Obviously I can't send them an access database, so copying the database record to an excel sheet seems the logical way to go. As it turns out, this is looking impossible. If you export a table to excel, it outputs a database table that is not readable. I would like to design an excel form so that it is neat and organized for someone else to read. I tried to use Dget functions to return table entries to an excel sheet that is designed the way I would like my form to look. My problem is that when I am done, all I have is an excel sheet with a bunch of formulas. What I want is only the output of the formulas, and not the stupid formulas themselves for people to read. Once my form is sent to someone else, obviously it will not be connected to the database anymore, and so the forumlas will not be displaying results at all! It appears impossible to copy the results of these forumulas into a form so that I can email it to someone. Is there a way to resolve this problem, or is it impossible to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import email addresses into a outlook distribution list | Excel Discussion (Misc queries) | |||
how I can sum or subtract 2 or 3 field in access in any record | New Users to Excel | |||
How to embed email link in excel document to distribution list | Excel Worksheet Functions | |||
How do I email just one record from an excel database. | Excel Discussion (Misc queries) | |||
Email distribution of certain cells, not an entire sheet/workbook | Excel Discussion (Misc queries) |