cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nsexton
Frequent Visitor

Using HTML to format SendEmail function

Hello,

 

I have been working on creating a simple app to send an email that contains the link of a survey when a button is pushed. All of the basic functionality is working I just do not know how to format the text inside the email. Here is the code inside the button function: 

 

Office365Outlook.SendEmail(Email_DataCard1.Default,"Test Survey 2", Title_DataCard1.Default & "," & Char(10) & Char(10) & "Please Complete Sample Survey Here: survey.com") 

 

I would like to use 11 point Calibri font if at all possible. 

 

Thank you all in advance!

2 ACCEPTED SOLUTIONS

Accepted Solutions
KrishnaV
Community Champion
Community Champion

hi @nsexton,

 

I have corrected some syntax errors in your code:

Office365Outlook.SendEmail(
Email_DataCard1.Default,
"Test Survey 2",
"<p style='font-family:calibri' size=11>"& Title_DataCard1.Default &",Please Complete Sample Survey Here: survey.com </font><br> ",
{
IsHtml:true,
Importance: "Normal"
}
)


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

View solution in original post

KrishnaV
Community Champion
Community Champion

Hi @nsexton ,

 

You can absolutely do whatever you want, try the below code:

Office365Outlook.SendEmail(
Email_DataCard1.Default,
"Test Survey 2",
"<img src='https://www.w3schools.com/images/lamp.jpg' alt='Lamp' width='32' height='32'><p style='font-family:calibri' size=11>"& Title_DataCard1.Default &",Please Complete Sample Survey Here: survey.com </font><br> ",
{
IsHtml:true,
Importance: "Normal"
}

 
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

View solution in original post

5 REPLIES 5
KrishnaV
Community Champion
Community Champion

Hi @nsexton ,

 

Try this below code:

Office365.SendEmail(
       "abc@abc.com",
       "Customer Care Report for " & ThisItem.Development & " Plot " & ThisItem.Plot_No & " (Bell Ref: " &ThisItem.BellRef & ")", 
       "<p style="font-family:calibri" size=11> Bell Customer Report</font><br> ", 
        {
           IsHtml:true,
           Importance: "Normal"
       }
)


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

Here is what my code looks like now, but it is giving me an Expected Operator error. 

 

Office365Outlook.SendEmail(
Email_DataCard1.Default,
"Test Survey 2",
"<p style="font-family:calibri" size=11> Title_DataCard1.Default & "," & Char(10) & Char(10) & "Please Complete Sample Survey Here: survey.com "</font><br> ",
{
IsHtml:true,
Importance: "Normal"
}
)

KrishnaV
Community Champion
Community Champion

hi @nsexton,

 

I have corrected some syntax errors in your code:

Office365Outlook.SendEmail(
Email_DataCard1.Default,
"Test Survey 2",
"<p style='font-family:calibri' size=11>"& Title_DataCard1.Default &",Please Complete Sample Survey Here: survey.com </font><br> ",
{
IsHtml:true,
Importance: "Normal"
}
)


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

Thank you for your help! Just for fun, do you know would i would be able to add an image into the email as well?

KrishnaV
Community Champion
Community Champion

Hi @nsexton ,

 

You can absolutely do whatever you want, try the below code:

Office365Outlook.SendEmail(
Email_DataCard1.Default,
"Test Survey 2",
"<img src='https://www.w3schools.com/images/lamp.jpg' alt='Lamp' width='32' height='32'><p style='font-family:calibri' size=11>"& Title_DataCard1.Default &",Please Complete Sample Survey Here: survey.com </font><br> ",
{
IsHtml:true,
Importance: "Normal"
}

 
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,903)