Hi
I am trying to create a button to send an email and I was able to accomplish the line break however I am having trouble loading preset data onto the email body, see the example below
Hi Team
I am having issues with Monitors
Monitors not turning on
Rep Name
UserName
Rep ID
Rep Team
Pc Make
PC Model
Pc Name
the information in Red is the open I need to extract from a table in SharePoint. when I add LookUp(RepsDataTSS,Office365Users.MyProfileV2().mail=RepEmail).RepUserName or anything for that matter it just types the formula. I'm new on this please assist if this is possible. I have the formulas as
Office365Outlook.SendEmail("rortiz10@wm.com", "Monitors/Mouse setting issue", "Hi Team"&Char(10)&"I am having trouble with my monitor's setting, When I try to go from one screen to another using my mouse I am unable to do so"&Char(10) &"LookUp(RepsDataTSS,Office365Users.MyProfileV2().mail=RepEmail).RepUserName")