Not sure why this is breaking my head but I am sure it is something I am missing (plus a lack of experience).
I have a combo box that allows multi-selection, in my case days of the week. The user selects Monday and Tuesday. The values - along with other text boxes - are stored in a collection:
As I am typing this, I realize that the space and schedule values are deemed as table. Still no light bulb.
If you expand the schedule, you will see the values:
When I try to email the values, I use this:
Office365Outlook.SendEmailV2("email@email.com",
"Collection Results",
Concat(Teams,
"Department: " & Department & Char(10) &
"Team Name: " & 'Team Name' & Char(10) &
"Number of Employees in the Team: " & 'Number of Members' & Char(10) &
"Space: " & dd_SpaceRequirement.Selected.Value & Char(10) &
"Days: " & Concat(Schedule, cb_Schedule.Selected.Day, ", " ) & Char(10)
))
The results:
What am I doing wrong? I need the Days to show Monday and Tuesday instead of Tuesday and Tuesday.
Thank you.
D.
