I've built a button to send out email with custom subject line with time included but the minute is not up to date by the time user send out.
Ex: it need to send this subject line: 1260/ss/yyyymmdd/hhmm/In.
the hhmm need to be real time at the time of pressed.
what's the best approach or function to put in OnSelect inside that Outlook365 function?
Solved! Go to Solution.
If it is based off of the exact time the button is pressed, then consider taking a snapshot of the time at that point. This can be done with a variable.
Ex. OnSelect:
Set(pressTime, Now())
You can then use that in your Subject line when the Email is sent:
ex. your subject: "1260/" & Text(pressTime, "ss/yyyymmdd/hhmm") & "/In"
I hope this is helpful for you.
If it is based off of the exact time the button is pressed, then consider taking a snapshot of the time at that point. This can be done with a variable.
Ex. OnSelect:
Set(pressTime, Now())
You can then use that in your Subject line when the Email is sent:
ex. your subject: "1260/" & Text(pressTime, "ss/yyyymmdd/hhmm") & "/In"
I hope this is helpful for you.
User | Count |
---|---|
183 | |
108 | |
88 | |
44 | |
42 |
User | Count |
---|---|
226 | |
108 | |
105 | |
68 | |
68 |