activities
latest
false
- Overview
- Excel
- Release Notes
- About the Excel activity package
- Project Compatibility
- Supported character encoding
- Project Settings
- Add or Update Excel Sensitivity Label
- Append Range
- Auto Fill
- Autofit Range
- Change Pivot Data Source
- Clear Sheet/Range/Table
- Copy/Paste Range
- Create Pivot Table
- Delete Column
- Delete Rows
- Delete Sheet
- Duplicate Sheet
- Export to CSV
- Fill Range
- Filter
- Filter Pivot Table
- Find First/Last Data Row
- Find/Replace Value
- For Each Excel Row
- For Each Excel Sheet
- Format As Table
- Format Cells
- Get Cell Color
- Get Excel Chart
- Get Excel Sensitivity Label
- Get Selected Range
- Insert Column
- Insert Chart
- Insert Rows
- Insert Sheet
- Invoke VBA
- Lookup
- Match Function
- Protect Sheet
- Read Cell Formula
- Read Cell Value
- Read Range
- Refresh Excel Data Connections
- Refresh Pivot Table
- Remove Duplicates
- Rename Sheet
- Run Spreadsheet Macro
- Save Excel File
- Save Excel File As
- Save Excel File As PDF
- Select Range
- Sort Range
- Text to Columns
- Unprotect Sheet
- Update Excel Chart
- Use Excel File
- VLookup
- Write Cell
- Write CSV
- Write DataTable to Excel
- Excel Application Scope
- Append To CSV
- Read CSV
- Write CSV
- Delete Column
- Filter Table
- Get Table Range
- Insert Column
- Sort Table
- Append Range
- Close Workbook
- Get Cell Color
- Read Cell
- Read Cell Formula
- Read Column
- Read Range
- Read Row
- Select Range
- Set Range Color
- Write Cell
- Write Range
- Save Workbook
- Create Table
- Get Workbook Sheet
- Get Workbook Sheets
- Refresh Pivot Table
- Create Pivot Table
- Get Selected Range
- Copy Sheet
- Delete Range
- Auto Fill Range
- Copy Paste Range
- Execute Macro
- Insert/Delete Columns
- Insert/Delete Rows
- Invoke VBA
- LookUp Range
- Remove Duplicates Range
- Excel Process Scope
- Manage CSV Files
- Filter CSV Files
- Verify CSV Files
- Table Functions
- Manage Multiple Excel Files
- Interpret Excel Results
- Manage Pivot Tables
- Manage Range Selection
- Read From Excel Files
- Manage Databases in Excel
- Compare CSV Files
- Compare Numeric Values
- Sort Data in Excel Files
- Filter and Delete Rows in Excel Files
- Manipulate Range Selections
- Verify Excel Workbook Data
- Read, Write, and Append Data in Excel
- Google Workspace
- Release notes
- About the Google Workspace activities package
- Project compatibility
- Wait for Calendar Event Created and Resume
- Wait for Calendar Event Received and Resume
- Wait for Calendar Event Replied and Resume
- Wait for Calendar Event Updated
- Wait for Email Received and Resume
- Wait for Email Sent and Resume
- Wait for File Created and Resume
- Wait for File Updated and Resume
- Wait for Folder Created and Resume
- Wait for Sheet Created and Resume
- Wait for Sheet Cell Updated and Resume
- Wait for Task Created and Resume
- Wait for Task Completed and Resume
- Add Attendee
- Create Event
- Delete Event
- Modify Event
- Search Events
- Use Google Drive
- Share File
- Delete File Permission
- Get File Permissions
- Update File Permission
- Copy File
- Create Folder
- Delete File
- Download File
- Find Files and Folders
- Get File Info
- Move File
- Upload File
- Create Document
- Create New Spreadsheet
- Get Mail Messages
- Send Mail Messages
- Change Labels
- Use Google Spreadsheet
- Add Delete Columns
- Add Delete Rows
- Auto Fill Range
- Add New Sheet
- Append Row
- Batch Spreadsheet Updates
- Copy Sheet
- Copy Paste Range
- Delete Range
- Delete Sheet
- Get Cell Color
- Get Sheets
- Read Cell
- Read Column
- Read Range
- Read Row
- Rename Sheet
- Write Cell
- Write Range
- Clear Range
- Download Spreadsheet
- Use Google Document
- Batch Document Updates
- Get Document
- Get Text Index
- Insert Text
- Replace Text
- Read All Text
- Create Script Project
- Get Project Content
- Upload Script File
- Create Deployment
- Run Script
- Mail
- Microsoft 365
- Release notes
- About the Microsoft 365 activity package
- Project compatibility
- Connections
- AddEmailCategories
- ArchiveEmail
- DeleteEmail
- DownloadEmail
- DownloadEmailAttachment
- DownloadEmailAttachments
- ForwardEmail
- GetEmail
- GetEmailAttachmentsInfo
- GetEmails
- GetMailFolders
- GetNewestEmail
- MarkEmailAsRead
- MarkEmailAsUnread
- MoveEmail
- RemoveEmailCategories
- ReplyToEmail
- SendEmail
- TurnOffAutomaticReplies
- TurnOnAutomaticReplies
- Merge multiple sheets into a new summary Excel sheet
- Automatically accept calendar invites from your manager
- Move files to dedicated folders by type
- Verify if new employment documents (I9 and ID) match
- Add new customers to a SharePoint List
- Delete SharePoint List items newer than yesterday
- Notify me on Slack when an important Outlook Email is received
- Include creation date in new OneDrive file names
- Notify me by email when a new file is created
- Microsoft 365 Scope
- Add Sheet
- Append Range
- Clear Range
- Copy Range
- Copy Sheet
- Create Workbook
- Delete Range
- Delete Sheet
- Get Cell Color
- Get Sheets
- Read Cell
- Read Column
- Read Range
- Read Row
- Rename Sheet
- Write Cell
- Write Range
- Set Range Color
- Create Table
- Get Table Range
- Insert Column
- Delete Column
- Insert Rows
- Delete Rows
- VLookup Range
- Use OneDrive & SharePoint
- Copy File/Folder
- Create Folder
- Delete File/Folder
- Download File
- Export File as PDF
- Find Files And Folders
- Get File/Folder
- Move File/Folder
- Upload File
- Share File/Folder
- For Each File/Folder
- Forward Mail
- Get Mail
- Move Mail
- Send Mail
- Reply to Mail
- Delete Mail
- Set Mail Categories
- Add Attachment
- Add Attendee
- Add Location
- Create Event
- Delete Event
- Find Meeting Times
- Get Calendars
- Modify Event
- RSVP
- Search Events
- Create Group
- Delete Group
- Get Group
- List Groups
- Create Bucket
- Delete Bucket
- List Buckets
- List Bucket Tasks
- Create Plan
- Get Plan
- List Plans
- Create Task
- Delete Task
- Get Task
- List Tasks
- Update Task
- For Each List
- Get List Info
- For Each List Item
- Delete List Item
- Add List Items
- Update List Item
- Get List Items
- Authentication troubleshooting
- AADSTS50011: Redirect URI mismatch
- AADSTS50076: Using multifactor authentication
- AADSTS50079: The user is required to use multifactor authentication
- AADSTS500113: No reply address registered for the application
- AADSTS65001: The user or administrator has not consented to use the application
- AADSTS7000218: The request body must contain the following parameter: client_assertion or client_secret
- AADSTS70002: InvalidClient - Error validating the credentials
- AADSTS50055: The password is expired
- AADSTS700082: The refresh token has expired due to inactivity
- AADSTS50194: Application is not configured as a multitenant application
- Mail troubleshooting
- Calendar troubleshooting
- Files troubleshooting
- Sheets troubleshooting
- Presentations
- Release Notes
- About the Presentations activity package
- Project Compatibility
- Add or Update Powerpoint Sensitivity Label
- Add Data Table to Slide
- Add File to Slide
- Add Image or Video to Slide
- Add New Slide
- Add Text to Slide
- Copy Paste Slide
- Delete Slide
- Format Slide Content
- Get Powerpoint Sensitivity Label
- Replace Text in Presentation
- Paste Item Into Slide
- Run Presentation Macro
- Save PowerPoint File As
- Save Presentation as PDF
- Use PowerPoint Presentation
- Word
- Release Notes
- About the Word Activities Package
- Project Compatibility
- Word Application Scope / Use Word File
- Add or Update Word Sensitivity Label
- Add Hyperlink to Document
- Add Picture
- Append Text
- Get Word Sensitivity Label
- Insert DataTable in Document
- Paste Chart/Picture Into Document
- Read Text
- Replace Picture
- Replace Text in Document
- Save Document As
- Save Document as PDF
- Set Bookmark Content
Send Calendar Invite
Productivity Activities
Last updated Nov 15, 2024
Send Calendar Invite
UiPath.Mail.Activities.Business.SendCalendarInviteX
Creates and sends a calendar invite. This activity must be added inside a Use Outlook 365, Use Gmail, or Use Desktop Outlook App activity.
In the Body of the Activity
- Account - Click Plus on the right side of the field and then, from the drop-down menu, select an Outlook 365, Gmail, or desktop Outlook account
added to the automation.
Note: If you are using Microsoft Outlook 2010 with an IMAP account, you can only send calendar invites from the default email account.
- Title/Subject - Click Plus on the right side of the field and then, from the menu, add a title for the invite:
- Data from the Project Notebook, a parent Excel file or email account.
- Use Saved Value - Use data that you previously saved for later use in the project.
- Text - Enter a title in the Text Builder.
- Ask when run - Prompt for the title when the project is executed.
- Open in Advanced Editor - Enter a VB expression.
- Required attendees - Click Plus on the right side of the field, and then use one of the options in the menu to select the required attendees:
- Data from the Project Notebook, a parent Excel file or email account. For example, you can select a cell in Excel with email addresses separated by semicolon (;) to add multiple recipients, or, when automating the Outlook desktop app, use the addresses from the To field of the email selected in Outlook when the project is executed.
- Use Saved Value - Use data in the form of a list of email addresses that you previously saved for later use in the project.
- Text - Enter one or more email addresses separated by semicolon (;) in the Text Builder.
- Ask when run - Prompt for recipients when the project is executed.
- Open in Advanced Editor - Enter a VB expression.
- Optional attendees - Click Plus on the right side of the field, and then use one of the options in the menu to select the optional attendees:
- Data from the Project Notebook, a parent Excel file or email account. For example, you can select a cell in Excel with email addresses separated by semicolon (;) to add multiple recipients, or, when automating the Outlook desktop app, use the addresses from the Cc field of the email selected in Outlook when the project is executed.
- Use Saved Value - Use data in the form of a list of email addresses that you previously saved for later use in the project.
- Text - Enter one or more email addresses separated by semicolon (;) in the Text Builder.
- Ask when run - Prompt for recipients when the project is executed.
- Open in Advanced Editor - Enter a VB expression.
- Start date - Click Plus on the right side of the field, and then select Choose Date/Time to select the date. Alternatively, you can use one of the other options from the menu to indicate the date:
- Data from the Project Notebook or a parent Excel file. For example, select a cell which contains a date.
- Ask when run - Prompt for the date when the project is executed.
- Open in Advanced Editor - Enter a VB expression.
- Start time - Click Plus on the right side of the field, and then select Choose Date/Time to select the start time. Alternatively, you can use one of the other options from the menu to indicate the start time:
- Data from the Project Notebook or a parent Excel file. For example, select a cell which contains the time.
- Ask when run - Prompt for the start time when the project is executed.
- Open in Advanced Editor - Enter a VB expression.
- Duration - Click Plus on the right side of the field, and then select Choose Duration to select the duration. Alternatively, you can use one of the other options from the menu to indicate the duration:
- Data from the Project Notebook or a parent Excel file. For example, select a cell which contains the duration.
- Ask when run - Prompt for the duration when the project is executed.
- Open in Advanced Editor - Enter a VB expression.
Note: Values from Excel must be exactly in the format of
HH:MM:SS
and the cell formatting must be set totext
. For example,01:30:00
.
- All day event - If selected, it marks the meeting as a full day event. This supersedes the Time and Duration settings.
- Location - Click Plus on the right side of the field, and then select one of the options from the menu to indicate the name of the room where to
hold the meeting:
- Data from the Project Notebook, a parent Excel file or email account.
- Use Saved Value - Use data that you previously saved for later use in the project.
- Text - Enter the room name in the Text Builder.
- Ask when run - Prompt for the room name when the project is executed.
- Open in Advanced Editor - Enter a VB expression.
- Description - You can add a plain text body or select a Word document to add the file in body of the invite.
- If you select Text, click Plus on the right side of the field, and then select one of the options from the menu to add the text for the body of the invite:
- Data from the Project Notebook, a parent Excel file or email account.
- Use Saved Value - Use data that you previously saved for later use in the project.
- Text - Enter the body text in the Text Builder.
- Ask when run - Prompt for the body text when the project is executed.
- Paste from clipboard - Paste a value that you previously copied to the clipboard in the project.
- Open in Advanced Editor - Enter a VB expression.
- If you select Use Word Document, indicate a Word document with tables, images. text formatting to add in the body. The invite body is formatted as HTML.
Click Browse next to the field, and then browse to a Word file and select it. Alternatively, you can indicate the path to a Word file
by selecting an option from the Plus menu on the right side of the field:
- Data from the Project Notebook, a parent Excel file or email account. For example, you can select a cell in an Excel file that contains a path.
- Use Saved Value - Use data in the form of a file path that you previously saved for later use in the project.
- Text - Enter a path in the Text Builder.
- Ask when run - Prompt for the path when the project is executed.
- Paste from clipboard - Paste a value that you previously copied to the clipboard in the project.
- Open in Advanced Editor - Enter a VB expression.
- Attachments - Select Files to
attach individual files or Folder to attach all the files in a
folder. To select the file or folder, click Browse
next to
the field, and then browse to the file or folder and select it.
Alternatively, you can indicate a file or folder path by selecting an
option from the Plus
menu on
the right side of the field:
- Data from the Project Notebook, a parent Excel file or email account. For example, you can select a cell in an Excel file that contains a path.
- Use Saved Value - Use data in the form of a path that you previously saved for later use in the project.
- Text - Enter a path in the Text Builder. You can combine text with a formula from an Excel file cell, for example to add a date to the file name using formulas in the Project Notebook.
- Ask when run - Prompt for the path when the project is executed.
- Paste from clipboard - Paste a value in the form of a path that you previously copied to the clipboard in the project.
- Open in Advanced Editor - Enter a VB expression.
- If you select Text, click Plus on the right side of the field, and then select one of the options from the menu to add the text for the body of the invite:
- Reminder - Click Plus on the right side of the field, and then select Choose Duration to select when to be reminded of this item. Alternatively, you can use one of the other options from the menu to indicate
the :
- Data from the Project Notebook or a parent Excel file. For example, select a cell which contains the duration between the reminder and the meeting.
- Open in Advanced Editor - Enter a VB expression.
- Show as - Select how to mark the time of this meeting on your calendar: Free, Tentative, Busy, Out of Office. The default option is Busy.
- Recurrence - Click Configure Recurrence to open a window where you can schedule the meeting to repeat regularly in a similar way to how you configure appointment recurrence in Outlook.
- Save without sending - If selected, the meeting is saved to your calendar, but the invite is not sent to the other attendees. This gives you a
chance to check the meeting in your email client before sending it. This option is selected by default.
Note: The options Out of Office and Save without sending are not supported in Gmail.
Properties Panel
Appointment Time
- See the options in the body of the activity.
Common
- DisplayName - The name displayed for the activity in the Designer panel.
Daily Recurrence
- Daily recurrence step - The number of days between the meetings in the series. Applies if Daily recurrence type is set to EveryNthDays.
- Daily recurrence type - The type of daily recurrence. Select EveryWeekDay to repeat on every weekday or EveryNthDays to repeat after the number of days set in Daily recurrence step.
- See the options in the body of the activity.
- Body document path - The path to the Word document to use as the body of the email, if Use document as body is selected.
Input
- Account - See Account in the body of the activity.
Misc
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
Monthly Recurrence
- Monthly recurrence day - The day of the week when to repeat the meeting. Applies if Monthly recurrence type is set to EveryNWeekDayOnEveryXthMonth.
- Monthly recurrence day index - The day of the month when to repeat the meeting. Applies if Monthly recurrence type is set to EveryNthDayOnEveryXMonth.
- Monthly recurrence step - The number of months between the meetings in the series.
- Monthly recurrence type - The type of monthly recurrence. Select EveryNWeekDayOnEveryXthMonth to repeat on the day set in Monthly recurrence day / MonthlyRecurrenceWeek, or EveryNthDayOnEveryXMonth to repeat on the day set in Monthly recurrence dayIndex.
- MonthlyRecurrenceWeek - The week of the month when to repeat the meeting on the day of the week set in Monthly recurrence day: First, Second, Third, Fourth, or Last. Applies if Monthly recurrence type is set to EveryNWeekDayOnEveryXthMonth.
Options
- Save without sending - See Save without sending in the body of the activity.
- Max body document size - The maximum size (in MB) a Word document can have to be used as the email body. The default value is 2MB.
- Use document as body - If selected, it indicates a Word document is added as the invite body. The document is defined in the Body document path field.
Range of Recurrence
- End date - The date by which to end the recurring meeting. Applies if Recurrence end type is set to ByDate.
- Recurrence end type - The type of ending for the series: ByDate, AfterNumberOfOcurrences, or NoEndDate.
- Recurrence total occurrences - The number of occurrences after which to end the meeting. Applies if Recurrence end type is set to AfterNumberOfOcurrences.
Recurrence Pattern
- Is recurring - If selected, indicates the meeting is recurring.
- Recurrence pattern type - The type of recurrence pattern: Daily, Weekly, Monthly, or Yearly.
Weekly Recurrence
- Weekly recurrence days - The day or days of the week when to repeat the meeting.
- Weekly recurrence step - The number of weeks between the meetings in the series.
Yearly Recurrence
- Yearly recurrence day - The day of the week when to repeat the meeting. Applies if Yearly recurrence type is set to EveryNthDayOfTheMonth.
- Yearly recurrence day index - The day of the month when to repeat the meeting. Applies if Yearly recurrence type is set to EverySpecificDay.
- Yearly recurrence month - The month during which to repeat the meeting. Applies if Yearly recurrence type is set to EverySpecificDay.
- Yearly recurrence step - The number of years between the meetings in the series.
- Yearly recurrence type - The type of yearly recurrence. Select EverySpecificDay to repeat on a specific day set in Yearly recurrenceDayIndex / Yearly recurrenceMonth, or EveryNthDayOfTheMonth to repeat after the number of days set in Yearly recurrence week and Yearly recurrence day.
- Yearly recurrence week - The week of the month when to repeat the meeting on the day of the week set in Yearly recurrence day: First, Second, Third, Fourth, or Last. Applies if Yearly recurrence type is set to EveryNthDayOfTheMonth.