D_Marcel
05-16-2014, 01:10 PM
Masters,
Greetings!
I'm finishing a small Excel project to control the employees in the context of a mentoring program. In the last part I'm coding the messages and the logic to sending them through the MS Outlook but I'm facing the "Type Mismatch" error since that I need to insert an array into the Outlook messages.
The error occurs when I'm trying to edit a registered employee and then call the routine to send the messages by pressing 'Save' and click on 'Yes' in the follow message. Strange that the error does not occur when the messages are created to a new employee, by pressing 'New', typing the data and then 'Save'.
I researched through hours but found nothing related to array into outlook messages.
I translated all the buttons, commands and messages to english and now I'm sharing this project with you in order to facilitate the understanding. There's also a list with dummy names to simulate real employees.
I would like to ask your help in this last part or give some directions of how can I code the messages. I thought about filter the target rows, then copy and paste into the message, but considering that this data will be right in the middle of the message, I don't know how to put the selected rows inside a variable.
Thanks in advance!
Kind regards,
Douglas Marcel
Greetings!
I'm finishing a small Excel project to control the employees in the context of a mentoring program. In the last part I'm coding the messages and the logic to sending them through the MS Outlook but I'm facing the "Type Mismatch" error since that I need to insert an array into the Outlook messages.
The error occurs when I'm trying to edit a registered employee and then call the routine to send the messages by pressing 'Save' and click on 'Yes' in the follow message. Strange that the error does not occur when the messages are created to a new employee, by pressing 'New', typing the data and then 'Save'.
I researched through hours but found nothing related to array into outlook messages.
I translated all the buttons, commands and messages to english and now I'm sharing this project with you in order to facilitate the understanding. There's also a list with dummy names to simulate real employees.
I would like to ask your help in this last part or give some directions of how can I code the messages. I thought about filter the target rows, then copy and paste into the message, but considering that this data will be right in the middle of the message, I don't know how to put the selected rows inside a variable.
Thanks in advance!
Kind regards,
Douglas Marcel