Access 2007 New attachment field

[Rocky]

I am thrilled with the new attachment field type in Access 2007.

Not sure how musch space it takes.

Is there any way of referencing an e-mail if one sends the e-mail from
Access?

Thanks

Rocky

 

[Pete D.]

Need a little more info on what your asking.

 

[Rocky]

- Show quoted text -

I use the following code to send an e-mail, which fetches the message
from the Form "a_tEXT".

Function E_Mail_EMAIL()
On Error GoTo E_Mail_EMAIL_Err

With CodeContextObject
DoCmd.OpenForm "a_tEXT", acNormal, "", "", , acNormal
DoCmd.RunCommand acCmdCopy
DoCmd.Close acForm, "a_tEXT"
DoCmd.SendObject , "", "HTML(*.html)", .[E-Mail], "", "",
"WINE FARMERS & FRUIT GROWERS EXHIBITION 2007", "", True, ""
End With


E_Mail_EMAIL_Exit:
Exit Function

E_Mail_EMAIL_Err:
MsgBox Error$
Resume E_Mail_EMAIL_Exit

End Function

What I want to do is reference the e-mail as an attachment in the new
Attachment Field, which will allow me to open the sent e-mail from
within Access.

Rocky

 

[Pete D.]

Email isn't one of the attachment supported file formats
http://office.microsoft.com/en-us/access/HA012138521033.aspx

Attachment isn't a pointer to a file, it is the actual file pulled into the
table and compressed for storage. There are ways to point to the email and
open it but requires some advance coding.

Desktop search or
Export email to supported file format and link to it or attach the exported
file
Their are other ways but not for the faint of heart.

Need a little more info on what your asking."Rocky"







- Show quoted text -

I use the following code to send an e-mail, which fetches the message
from the Form "a_tEXT".

Function E_Mail_EMAIL()
On Error GoTo E_Mail_EMAIL_Err

With CodeContextObject
DoCmd.OpenForm "a_tEXT", acNormal, "", "", , acNormal
DoCmd.RunCommand acCmdCopy
DoCmd.Close acForm, "a_tEXT"
DoCmd.SendObject , "", "HTML(*.html)", .[E-Mail], "", "",
"WINE FARMERS & FRUIT GROWERS EXHIBITION 2007", "", True, ""
End With


E_Mail_EMAIL_Exit:
Exit Function

E_Mail_EMAIL_Err:
MsgBox Error$
Resume E_Mail_EMAIL_Exit

End Function

What I want to do is reference the e-mail as an attachment in the new
Attachment Field, which will allow me to open the sent e-mail from
within Access.

Rocky

 

[Rocky]

Email isn't one of the attachment supported file formatshttp://office.microsoft.com/en-us/access/HA012138521033.aspx

Attachment isn't a pointer to a file, it is the actual file pulled into the
table and compressed for storage. There are ways to point to the email and
open it but requires some advance coding.

Desktop search or
Export email to supported file format and link to it or attach the exported
file
Their are other ways but not for the faint of heart.

I use the following code to send an e-mail, which fetches the message
from the Form "a_tEXT".

Function E_Mail_EMAIL()
On Error GoTo E_Mail_EMAIL_Err

With CodeContextObject
DoCmd.OpenForm "a_tEXT", acNormal, "", "", , acNormal
DoCmd.RunCommand acCmdCopy
DoCmd.Close acForm, "a_tEXT"
DoCmd.SendObject , "", "HTML(*.html)", .[E-Mail], "", "",
"WINE FARMERS & FRUIT GROWERS EXHIBITION 2007", "", True, ""
End With

E_Mail_EMAIL_Exit:
Exit Function

E_Mail_EMAIL_Err:
MsgBox Error$
Resume E_Mail_EMAIL_Exit

End Function

What I want to do is reference the e-mail as an attachment in the new
Attachment Field, which will allow me to open the sent e-mail from
within Access.

Rocky- Hide quoted text -

- Show quoted text -

Thanks for the link.

I guess I am trying to emulate a CRM like Goldmine or Maximiser,
keeping track of documents and e-mails sent to clients and then using
the reference to open the document

Rocky

 

[Pete D.]

What you can do is add those people/companies to your contacts using access
to add if doesn' t exist or link if does. Access can then link to and open
the contact where you can click on activity. This would probally be the
easyest and actually link it all together pretty neatly. It would also link
you to appointments with, complete info on contact and make sending follow
up emails easy.

Email isn't one of the attachment supported file
formatshttp://office.microsoft.com/en-us/access/HA012138521033.aspx

Attachment isn't a pointer to a file, it is the actual file pulled into
the
table and compressed for storage. There are ways to point to the email
and
open it but requires some advance coding.

Desktop search or
Export email to supported file format and link to it or attach the
exported
file
Their are other ways but not for the faint of heart.

Need a little more info on what your asking."Rocky"


I am thrilled with the new attachment field type in Access 2007.

Not sure how musch space it takes.

Is there any way of referencing an e-mail if one sends the e-mail
from
Access?

Rocky- Hide quoted text -

- Show quoted text -

I use the following code to send an e-mail, which fetches the message
from the Form "a_tEXT".

Function E_Mail_EMAIL()
On Error GoTo E_Mail_EMAIL_Err

With CodeContextObject
DoCmd.OpenForm "a_tEXT", acNormal, "", "", , acNormal
DoCmd.RunCommand acCmdCopy
DoCmd.Close acForm, "a_tEXT"
DoCmd.SendObject , "", "HTML(*.html)", .[E-Mail], "", "",
"WINE FARMERS & FRUIT GROWERS EXHIBITION 2007", "", True, ""
End With

E_Mail_EMAIL_Exit:
Exit Function

E_Mail_EMAIL_Err:
MsgBox Error$
Resume E_Mail_EMAIL_Exit

End Function

What I want to do is reference the e-mail as an attachment in the new
Attachment Field, which will allow me to open the sent e-mail from
within Access.

Rocky- Hide quoted text -

- Show quoted text -

Thanks for the link.

I guess I am trying to emulate a CRM like Goldmine or Maximiser,
keeping track of documents and e-mails sent to clients and then using
the reference to open the document

Rocky

 

[Rocky]

What you can do is add those people/companies to your contacts using access
to add if doesn' t exist or link if does. Access can then link to and open
the contact where you can click on activity. This would probally be the
easyest and actually link it all together pretty neatly. It would also link
you to appointments with, complete info on contact and make sending follow
up emails easy.

Email isn't one of the attachment supported file
formatshttp://office.microsoft.com/en-us/access/HA012138521033.aspx
Attachment isn't a pointer to a file, it is the actual file pulled into
the
table and compressed for storage. There are ways to point to the email
and
open it but requires some advance coding.
Desktop search or
Export email to supported file format and link to it or attach the
exported
file
Their are other ways but not for the faint of heart.

Need a little more info on what your asking."Rocky"

I am thrilled with the new attachment field type in Access 2007.
Not sure how musch space it takes.
Is there any way of referencing an e-mail if one sends the e-mail
from
Access?
Thanks
Rocky- Hide quoted text -
- Show quoted text -
I use the following code to send an e-mail, which fetches the message
from the Form "a_tEXT".
Function E_Mail_EMAIL()
On Error GoTo E_Mail_EMAIL_Err
With CodeContextObject
DoCmd.OpenForm "a_tEXT", acNormal, "", "", , acNormal
DoCmd.RunCommand acCmdCopy
DoCmd.Close acForm, "a_tEXT"
DoCmd.SendObject , "", "HTML(*.html)", .[E-Mail], "", "",
"WINE FARMERS & FRUIT GROWERS EXHIBITION 2007", "", True, ""
End With
E_Mail_EMAIL_Exit:
Exit Function
E_Mail_EMAIL_Err:
MsgBox Error$
Resume E_Mail_EMAIL_Exit
End Function
What I want to do is reference the e-mail as an attachment in the new
Attachment Field, which will allow me to open the sent e-mail from
within Access.
Rocky- Hide quoted text -
- Show quoted text -

Thanks for the link.

I guess I am trying to emulate a CRM like Goldmine or Maximiser,
keeping track of documents and e-mails sent to clients and then using
the reference to open the document

Rocky- Hide quoted text -

- Show quoted text -

Thanks Pete, sounds like a pretty easy solution for those in the know.

CXuld you pint me toi a site where I can look at some code to
seamlessly interact between Access and Outlook,
bearing in mind that the users of my program may not have the same
version of Acees

Rocky