Hi,
I have 2 workbooks which I created for work which I have linked to each other.
I need to send one of the spreadsheets to my boss via internal e-mail every monday morning. I am new to excel and still feeling my way.
I created a macro to send the file however, I need to insert my boss's name into the TO: Field of the email. The Subject is already there when I click the macro button but that's it. I can input the name manually but I need this to be automated for other staff.
Can you help Please
I have 2 workbooks which I created for work which I have linked to each other.
I need to send one of the spreadsheets to my boss via internal e-mail every monday morning. I am new to excel and still feeling my way.
I created a macro to send the file however, I need to insert my boss's name into the TO: Field of the email. The Subject is already there when I click the macro button but that's it. I can input the name manually but I need this to be automated for other staff.
Can you help Please