Search results

Hi, The tbl_Employee contains 3 fields OriginatorID, FullName & EmailAddress. This table is populated with a list of employee names & email accounts. The tbl_ECNList contains many fields that aren't relative to my problem. I have a relationship between the two OriginatorID fields of the two...

Hi, I am currently working on a split database. The Back_End contains all the tables. The Front_End contains the queries, forms, reports, modules, macros etc, etc. I have a table named tbl_ECNList this contains fields named OriginatorID, FullName & EmailAddress. I have another table named...

Thanks Trevor I look forward to learning and fast ! Cheers, Steve.

If I want to achieve an email that will look like this: To: "Address" (Where "Address" is in the recipients email address taken from the Email form control of the access database Form) Email Subject: Your ECN No ???? has had it's status updated. (Where the ???? is taken from the ECNNo form...

Call MailDoc.ReplaceItemValue("SendTo", "<Email Address>") The message SendTo address "<Email Address>" will be taken from one of the database Form Source Controls named "Email" ' Set subject. Call MailDoc.ReplaceItemValue("Subject", "<Subject Text>") The "<Subject Text>" will go into...

Hi Guys & Gals, I am an absolute beginner so please bear with me if I ask some what may seem rediculous questions !! I am keen to learn so any help received I can say is very appreciated. Cheers, Steve.

This is the code that works to send the email:- Private Sub Command131_Click() ' Set up the objects required for Automation into Lotus Notes. Dim Maildb As Object 'The mail database. Dim UserName As String 'The current users Lotus Notes name. Dim...

Hi All, I hope someone out there can help me resolve a 'Event Procedure' problem I have. I want to send a automated email via Lotus Notes to inform a database user that a record has been updated. I have got the automated email working to send a email to myself and save it into the sent items...