If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 Forms
I want to send a specific form record with it's attachments to an individual.
Is this a reasonable request, or do I need to develop a macro that can help? |
#2
|
|||
|
|||
Access 2007 Forms
Cris,
Form? Did you mean you want to send a report with attachments? Please elaborate... And while you're at it going to need Access version to give you a proper answer. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cris" wrote in message ... I want to send a specific form record with it's attachments to an individual. Is this a reasonable request, or do I need to develop a macro that can help? |
#3
|
|||
|
|||
Access 2007 Forms
On Sun, 17 Jan 2010 14:08:01 -0800, Cris
wrote: I want to send a specific form record with it's attachments to an individual. Is this a reasonable request, or do I need to develop a macro that can help? An Access Form has no existance outside its database; for that matter there is not really any such thing as "a form record" - a record exists in a Table, and only in a Table; the form is just a window, a tool to let you see and work with the data in the table. What exactly do you want the recipient to get? The data in the form in a way that they can look at it? The attachments as files that they can bring into (say) Word or Excel or some other program? The same view of the data as seen by the person with Access installed, editable and all? or what? -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Access 2007 Forms
I am using Access 2007. When looking at a record (through a form), I want
to email that specific record to a recipient using Outlook 2007. The record has attachments stored in the Attachments Data Type field. I would like the attachments to be a live link in the email. Thank you, Cris "Gina Whipp" wrote: Cris, Form? Did you mean you want to send a report with attachments? Please elaborate... And while you're at it going to need Access version to give you a proper answer. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cris" wrote in message ... I want to send a specific form record with it's attachments to an individual. Is this a reasonable request, or do I need to develop a macro that can help? . |
#5
|
|||
|
|||
Access 2007 Forms
Thank you John. I do understand that the form is simply a lens for the
underlying stored record. What I need to do, is create a way for users to be looking at a record in a form (Access 2007), and be able to send that specific record to an Outlook recipient. The record on screen will have attachments that I would like to transfer as live links to the Outlook email. Ideally, the email would look like the record in the form, but would not need to be editable. I hope this explains further what I'm needing to do. Cris "John W. Vinson" wrote: On Sun, 17 Jan 2010 14:08:01 -0800, Cris wrote: I want to send a specific form record with it's attachments to an individual. Is this a reasonable request, or do I need to develop a macro that can help? An Access Form has no existance outside its database; for that matter there is not really any such thing as "a form record" - a record exists in a Table, and only in a Table; the form is just a window, a tool to let you see and work with the data in the table. What exactly do you want the recipient to get? The data in the form in a way that they can look at it? The attachments as files that they can bring into (say) Word or Excel or some other program? The same view of the data as seen by the person with Access installed, editable and all? or what? -- John W. Vinson [MVP] . |
#6
|
|||
|
|||
Access 2007 Forms
Cris,
You can't eMail the from, as John explains in his reply. You will need a report and as for the attachments, you will need to attach those as well, to your eMail. Now I suppose you could capture a *screen shot* and place that in the body of the eMail and then attach your attachments but I have not ever done it this way as the forms are not to be used for that purpose. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cris" wrote in message ... I am using Access 2007. When looking at a record (through a form), I want to email that specific record to a recipient using Outlook 2007. The record has attachments stored in the Attachments Data Type field. I would like the attachments to be a live link in the email. Thank you, Cris "Gina Whipp" wrote: Cris, Form? Did you mean you want to send a report with attachments? Please elaborate... And while you're at it going to need Access version to give you a proper answer. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cris" wrote in message ... I want to send a specific form record with it's attachments to an individual. Is this a reasonable request, or do I need to develop a macro that can help? . |
#7
|
|||
|
|||
Access 2007 Forms
Thank You.
"Gina Whipp" wrote: Cris, You can't eMail the from, as John explains in his reply. You will need a report and as for the attachments, you will need to attach those as well, to your eMail. Now I suppose you could capture a *screen shot* and place that in the body of the eMail and then attach your attachments but I have not ever done it this way as the forms are not to be used for that purpose. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cris" wrote in message ... I am using Access 2007. When looking at a record (through a form), I want to email that specific record to a recipient using Outlook 2007. The record has attachments stored in the Attachments Data Type field. I would like the attachments to be a live link in the email. Thank you, Cris "Gina Whipp" wrote: Cris, Form? Did you mean you want to send a report with attachments? Please elaborate... And while you're at it going to need Access version to give you a proper answer. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cris" wrote in message ... I want to send a specific form record with it's attachments to an individual. Is this a reasonable request, or do I need to develop a macro that can help? . . |
#8
|
|||
|
|||
Access 2007 Forms
You're welcome!
-- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cris" wrote in message ... Thank You. "Gina Whipp" wrote: Cris, You can't eMail the from, as John explains in his reply. You will need a report and as for the attachments, you will need to attach those as well, to your eMail. Now I suppose you could capture a *screen shot* and place that in the body of the eMail and then attach your attachments but I have not ever done it this way as the forms are not to be used for that purpose. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cris" wrote in message ... I am using Access 2007. When looking at a record (through a form), I want to email that specific record to a recipient using Outlook 2007. The record has attachments stored in the Attachments Data Type field. I would like the attachments to be a live link in the email. Thank you, Cris "Gina Whipp" wrote: Cris, Form? Did you mean you want to send a report with attachments? Please elaborate... And while you're at it going to need Access version to give you a proper answer. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Cris" wrote in message ... I want to send a specific form record with it's attachments to an individual. Is this a reasonable request, or do I need to develop a macro that can help? . . |
Thread Tools | |
Display Modes | |
|
|