Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / November 2006

Tip: Looking for answers? Try searching our database.

Open Outlook and Reference a Field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JS - 27 Oct 2006 16:41 GMT
I created a database that is being used by several departments.  When a
record is created, the user notifies the person in the next department via
email that their is a record ready to be coded.  The user will be able to
search for the Item ID that is referenced in the email.  When the coding is
complete, the coder notifies the next department via that thier is a record
ready to be audited, etc.

I created a button that lauches outlook so the user does not have to leave
the main entry form.  

Right now, the user clicks on the button to open outlook and then has to
enter the # of the Item ID in the body of the message.  Is is possible for
the email to automatically reference the current record in the body of the
message which would be the [Item ID] field?  So the only thing the user has
to do is send to the appropriate person.

Thanks,
JS
BruceS - 29 Oct 2006 23:20 GMT
JS:

DoCmd.SendObject  allows you to specify the body text:

SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject,
MessageText, EditMessage, TemplateFile)

In the MessageText parameter, simply include something like:

..., "Your Item ID is " & Me![ItemID] & ".", ...

Use the "SendNoObject" if you don't have an attachment.  Search for
SendObject in VBA help for more details.

Bruce

> I created a database that is being used by several departments.  When a
> record is created, the user notifies the person in the next department via
[quoted text clipped - 14 lines]
> Thanks,
> JS
JS - 01 Nov 2006 18:26 GMT
Thank you Bruce for your response.  I will give it a try!

> JS:
>
[quoted text clipped - 30 lines]
> > Thanks,
> > JS
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.