HELP

(1) Share

Report

Posted on by AW-22041745-0

I'm trying to get my form to send an email to a specific email address. But now I'm left with an error message that I don't understand.

Office365Outlook.SendEmailV2(
"xxxx@hotmail.se";
"Cancellation";
"Type of order:"&Typ.Selected.Value&Char(10)&Char(10)&
"Train number:"&Tagnr.Text&Char(10)&
"Date:"&Datum.Text&Char(10)&
"Time:"&Klocka.Text&Char(10)&Char(10)&
"Departure city:"&StartOrt.Text&Char(10)&
"Arrival city:"&SlutOrt.Text&Char(10)&Char(10)&
"Name:"&Namn.Text&Char(10)&
"Phone:"&Telefon.Text&Char(10)&Char(10)&
"Additional information:"&Upplysning.Text
);
Reset(Typ);
Reset(StartOrt);
Reset(SlutOrt);
Reset(Tagnr);
Reset(Date);
Reset(Clock);
Reset(Name);
Reset(Phone);
Reset(Information);

The error message I get is the following

Unexpected character. Characters are used in an unexpected way in the formula.

For example, the character " is not expected after a number, such as in: "32". A space ("32 ") should be expected, so that only the number 32, or another number (such as in "323") is expected.

Location

*Button

.OnSelect

How to solve

Remove or insert the unexpected characters.

What am I doing wrong?

Jag försöker få mitt formulär att skicka i väg ett mail till en specifik e-post. Men nu har jag ett felmeddelande kvar som jag inte förstår mig på.

Office365Outlook.SendEmailV2(
"xxxx@hotmail.se";
"Cancellation";
"Type of order:"&Typ.Selected.Value&Char(10)&Char(10)&
"Train number:"&Tagnr.Text&Char(10)&
"Date:"&Datum.Text&Char(10)&
"Time:"&Klocka.Text&Char(10)&Char(10)&
"Departure city:"&StartOrt.Text&Char(10)&
"Arrival city:"&SlutOrt.Text&Char(10)&Char(10)&
"Name:"&Namn.Text&Char(10)&
"Phone:"&Telefon.Text&Char(10)&Char(10)&
"Additional information:"&Upplysning.Text
);
Reset(Typ);
Reset(StartOrt);
Reset(SlutOrt);
Reset(Tagnr);
Reset(Datum);
Reset(Klocka);
Reset(Namn);
Reset(Telefon);
Reset(Upplysning);

Felmeddelande som jag får är följande

Oväntat tecken. Tecken används på ett oväntat sätt i formeln.

Tecknet " förväntas t.ex. inte efter ett tal, som exempelvis i: "32". Ett blanksteg ("32 ") borde förväntas, så att det bara är talet 32, eller ett annat tal (som i "323") som förväntas.

Plats

*Knapp

.OnSelect

Så här löser du

Ta bort eller sätt de oväntade tecknen.

Vad gör jag för fel ????

Categories:

Error handling

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AW-22041745-0,

You need a different function separator - I assume you are using European syntax, which is ; and ;; instead of , and ;
Office365Outlook.SendEmailV2( "xxxx@hotmail.se"; "Cancellation"; "Type of order:" & Typ.Selected.Value & Char(10) & Char(10) & "Train number:" & Tagnr.Text & Char(10) & "Date:" & Datum.Text & Char(10) & "Time:" & Klocka.Text & Char(10)& Char(10) & "Departure city:" & StartOrt.Text & Char(10) & "Arrival city:" & SlutOrt.Text & Char(10) & Char(10) & "Name:" & Namn.Text & Char(10) & "Phone:" & Telefon.Text & Char(10) & Char(10) & "Additional information:" & Upplysning.Text );; Reset(Typ);; Reset(StartOrt);; Reset(SlutOrt);; Reset(Tagnr);; Reset(Date);; Reset(Clock);; Reset(Name);; Reset(Phone);; Reset(Information);;

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@AW-22041745-0

Office365Outlook.SendEmailV2(
"xxxx@hotmail.se";
"Cancellation";
"Type of order: " & Typ.Selected.Value & Char(10) & Char(10) &
"Train number: " & Tagnr.Text & Char(10) &
"Date: " & Datum.Text & Char(10) &
"Time: " & Klocka.Text & Char(10) & Char(10) &
"Departure city: " & StartOrt.Text & Char(10) &
"Arrival city: " & SlutOrt.Text & Char(10) & Char(10) &
"Name: " & Namn.Text & Char(10) &
"Phone: " & Telefon.Text & Char(10) & Char(10) &
"Additional information: " & Upplysning.Text
);

Reset(Typ);
Reset(StartOrt);
Reset(SlutOrt);
Reset(Tagnr);
Reset(Datum);
Reset(Klocka);
Reset(Namn);
Reset(Telefon);
Reset(Upplysning);

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@WarrenBelz

sorry did not see your response

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(0)

Report
Copy link

Link copied!

@AW-22041745-0

Just wanted to check in and see if everything is working now. If you still need any help, feel free to let me know.

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @AW-22041745-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No