MS Office Variables

This workflow forwards the email as follows:

• The email is forwarded to two recipients.

• No recipients are on CC.

• The subject of the email will not be modified.

• The text Forwarded Email Below will be displayed above the contents of the forwarded email.

• The email will be prepared but will not be sent automatically.

To test this example in the sample project:

1. Start the project.

   

2. Send an email to your Outlook inbox.

3. Wait until the email is received.

4. Select the tab for the Forward workflow.

5. Click Run Workflow.

   

   The email will be prepared and displayed.

   

This workflow stores the body of the email in HTML format in the text variable text.

It then writes the contents of the variable text to the file at c:/temp/email.html.

To test this example in the sample project:

1. Make sure that you have a folder at c:/temp. Create the folder if needed.

2. Start the project.

   

3. Send an email to your Outlook inbox. Include some text in the body of the email.

4. Wait until the email is received.

5. Select the tab for the Get_Body_as_HTML workflow.

6. Click Run Workflow.

   

   The variable text is populated.

   

   Open the file at c:/temp/email.html in a text editor to view the contents of the email in HTML format.

   

This workflow retrieves a list of the attachments to the email and stores the list in the variable List_of_Outlook_Attachments which is a list of type Outlook Attachment.

To test this example in the sample project:

1. Start the project.

   

2. Send an email with multiple small attachments to your Outlook inbox.

3. Wait until the email is received.

4. Select the tab for the Get_List_of_Attachments workflow.

5. Click Run Workflow.

   

   The list List_of_Attachments is populated. In this example, the email had three attachments. The names of those files are listed.

   

This workflow moves the email to the _Work subfolder under the user's Inbox.

To test this example in the sample project:

1. Open the tab for the Move to Outlook Folder workflow.

2. Instead of the email address entered (mark.lee@nice.com), enter your own address.

3. Enter the name of a subfolder in your inbox in place of the subfolder name _Work.

4. Start the project.

   

5. Send an email to your Outlook inbox.

6. Click Run Workflow.

   

7. Wait until the email is received.

   The email should be located in the Outlook subfolder your specified.

   

This workflow replies to the email as follows:

• The reply will be sent to the sender only.

• The subject of the email will not be modified.

• The text Thank you, I completely agree! will be displayed above the contents of the email being replied to.

• The email will be prepared but not sent automatically.

To test this example in the sample project:

1. Start the project.

   

2. Send an email to your Outlook inbox.

   

3. Wait until the email is received.

4. Select the tab for the Reply workflow.

5. Click Run Workflow.

   

   The email will be prepared and displayed.

   

This workflow saves the email as a message file at c:/temp/new_mail.msg and overwrites the file if it already exists.

To test this example in the sample project:

1. Make sure that you have a folder at c:/temp. Create the folder if needed.

2. Start the project.

   

3. Send an email to your Outlook inbox.

4. Wait until the email is received.

5. Select the tab for the Save_as_Message_File workflow.

6. Click Run Workflow.

   

7. Navigate to c:/temp and preview the file new_mail.msg.

   

This workflow stores the alias of the sender in the text variable text.

To test this example in the sample project:

1. Start the project.

   

2. Send an email to your Outlook inbox from Outlook, for example:

   

3. Wait until the email is received.

4. Select the tab for the Get_Sender_Alias workflow.

5. Click Run Workflow.

   

   The alias of the sender is stored in the variable text.

   

   Note that the actual email address of the sender is stored in the Sender property of the Outlook Mail Item variable.

   

This workflow saves all attachments to an email in a folder c:/temp/attachments. Each workflow step is explained below.

1. The workflow invokes the workflow Get_List_of_Attachments which populates the list of type Outlook Attachment called List_of_Outlook_Attachments with a list of all attachments to the email. This step is explained in the example for Get List of Attachments.

   

2. The workflow waits until the Get_List_of_Attachments workflow ends. The transition to the next step is conditional on the Ended event of the Get_List_of_Attachments workflow.

   

3. The attachments are then saved.

   

   1. A For Each statement is used to cycle through Outlook attachments in the list List_of_Outlook_Attachments.

   2. The Outlook attachment from the current iteration is stored in the Outlook Attachment variable Outlook_Attachment.

   3. The Save Attachment method is used to save the file of the current attachment. To specify the full path of the file to save, use the Concatenate function to combine the path (c:/temp/attachments) with the name to give the file. In this example, the file is saved with the same name with which it was received, as stored in its File Name property.

To test this example in the sample project:

1. Make sure that you have a folder at c:/temp/attachments. Create the folder if needed.

2. Start the project.

   

3. Send an email to your Outlook inbox. Include three small attachments.

   

4. Wait until the email is received.

5. Select the tab for the Save_Attachments workflow.

6. Click Run Workflow.

   

7. Navigate to the folder c:/temp/attachments.

   The files should be saved in the folder.