Hello!
I've been trying to sort this out, but haven't been able to make it work. Pretty green on VBA, so bear with me.
I have a form, and technicians use it to enter call information. I was able to put it all into a report, which could be done by sendobject (although I'm not able to quite get that working right, which probably shows how green I am). My desired end goal would be to create text email that would populate with the correct fields in an outlook email for only the current record viewed in the form.
For example (brackets indicate Field Name)
"Hello,
We have received a [Call_Type] call on [Initial_Call_Date] concerning [First] [Last].
The Vendor is [Vendor].
The reporting party is [Reporter Name] ([Reporter_Type]), who can be reached by [Reporter_Phone].
Phone call summary is:
[CaseLog_Initial]
Our ongoing phone call summary is:
[CaseLog_Ongoing]
The call is considered [Status]."
I also have another email distribution list, that I'd like to keep dynamic. The list is under a table titled "Email_List", and just has an ID and Email field.
Table is titled "Calls"
Form is titled "Frm-ALL"
Any help with a VBA code that could create the email would be appreciated. Is there a straight forward way to code this?
I've been trying to sort this out, but haven't been able to make it work. Pretty green on VBA, so bear with me.
I have a form, and technicians use it to enter call information. I was able to put it all into a report, which could be done by sendobject (although I'm not able to quite get that working right, which probably shows how green I am). My desired end goal would be to create text email that would populate with the correct fields in an outlook email for only the current record viewed in the form.
For example (brackets indicate Field Name)
"Hello,
We have received a [Call_Type] call on [Initial_Call_Date] concerning [First] [Last].
The Vendor is [Vendor].
The reporting party is [Reporter Name] ([Reporter_Type]), who can be reached by [Reporter_Phone].
Phone call summary is:
[CaseLog_Initial]
Our ongoing phone call summary is:
[CaseLog_Ongoing]
The call is considered [Status]."
I also have another email distribution list, that I'd like to keep dynamic. The list is under a table titled "Email_List", and just has an ID and Email field.
Table is titled "Calls"
Form is titled "Frm-ALL"
Any help with a VBA code that could create the email would be appreciated. Is there a straight forward way to code this?