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.

Displaying field entries from within an sent email - How to?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Adam - 16 Nov 2006 09:01 GMT
Hello all,

I have a form with a button in it which sends an email to a specified
address when pressed. I would like the message to contain the form number of
the form from which the email was sent. (i.e. - if the email is sent from
form 2, the message would say something like....blah blah form 2 blah blah
blah...). My attempt was the following:

strMsgBody = "Issue no.[table]![Database Reference No]  blah, blah, blah"

Where table was my table holding the field 'Database Reference number which
I wanted to reference'.

My attempt, didn't work (just produced literally what I'd written)

Many thanks.

Adam
Alex Dybenko - 16 Nov 2006 09:20 GMT
Just replied to your first post

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hello all,
>
[quoted text clipped - 16 lines]
>
> Adam
Adam - 16 Nov 2006 09:36 GMT
Thanks Alex!

Sorry, I forgot what I'd entitled the previous post and couldn't see it this
morning.

I'll check it now.

Best regards

Adam

> Hello all,
>
[quoted text clipped - 14 lines]
>
> Adam
 
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.