Concatenated Email Title

jjake

Registered User.
Local time
Today, 13:04
Joined
Oct 8, 2015
Messages
291
I have a form with a autonumber field named [WorkOrderID].

I have a button that when clicked generates a report based on the form then auto emails it with the title "New Work Order".

I am trying to get the title to concatenate the "New Work Order" with the current [WorkOrderID] and put them together.

e.g New Work Order #193

the 193 is from the [WorkOrderID] Field and "New Work Order #" Is just text put in the VBA code.

Thanks,
 
strTitle="New Work Order #" & Me.WorkOrderId
 
Perfect Thanks.
 

Users who are viewing this thread

Back
Top Bottom