Search results
-
A
Email Fields - Auto Filling in from stored data
Scooterbug? You are a legend :D I managed to dabble with your suggestion sSecondToField = DLookup("[EmailAddressFieldName]","tblUsers", & _ "[UniqueFieldName]"= & Chr(34) & UserUniqueField & chr(34)) & ";" became sSecondToField = DLookup("[EmailAdd]", "qryCompLogForReport") Report was...- AstroDonut
- Post #5
- Forum: Modules & VBA
-
A
Email Fields - Auto Filling in from stored data
Hi, Using vba I've managed to get the initial letters of the person creating a record onto the unique reference the unique reference is like this ->> T-1009/10/BW BW is the initials of the user creating the record, this reference is related to "Bob Walker" in tblUser, also in tblUser is a...- AstroDonut
- Post #3
- Forum: Modules & VBA
-
A
Email Fields - Auto Filling in from stored data
Hi, I have used DoCmd.SendObject to create an email with a report attached, I found a snippet of code to insert the unique reference into the 'Subject:' field on the email. I tried playing around with it to solve my problem and it failed!! So... I have a table of users with an ID, first...- AstroDonut
- Thread
- Replies: 4
- Forum: Modules & VBA