Access 2007 Forms

  • Thread starter Thread starter Cris
  • Start date Start date
C

Cris

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?
 
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
 
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?
Click to expand...

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?
 
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
 
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
 
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
 
Thank You.

Gina Whipp said:
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




.
Click to expand...
 
Back
Top