Pontybiker
New member
- Joined
- May 4, 2016
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi,
If possible, I would like the ability to select text from an excel workbook and email it to an email address. The email address would be dependent on what text is in a certain cell.
This is an example of the workbook containing the data (workbook A):
This is an example of the email workbook (workbook B);
So the code would need to email the row of text in workbook A to the email address in workbook B by matching the text in column A in workbook A to the correct email address in column B in workbook B.
I hope this makes sense. I realise this may be asking a lot. As always, I honestly do appreciate anyone's help with these questions.
Kind regards,
J.
If possible, I would like the ability to select text from an excel workbook and email it to an email address. The email address would be dependent on what text is in a certain cell.
This is an example of the workbook containing the data (workbook A):
| Sport | £1 | £2 | AAAA |
| Education | £2 | £2 | BBBB |
| Managment | £6 | £1 | CCCC |
| Art | £4 | £3 | DDDD |
This is an example of the email workbook (workbook B);
| Sport | j@j.com |
| Education | b@j.com |
| Management | g@j.com |
| Art | k@j.com |
So the code would need to email the row of text in workbook A to the email address in workbook B by matching the text in column A in workbook A to the correct email address in column B in workbook B.
I hope this makes sense. I realise this may be asking a lot. As always, I honestly do appreciate anyone's help with these questions.
Kind regards,
J.