Multiple email addresses in one cell

It is not quite correct to say that Excel only acts on the first hyperlink in a cell, because there can be only one hyperlink in a cell.

This can be done with VBA. What are you using as a separator between the email addresses? Can you give a small sample file with fake email addresses?

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

What code have you got/tried already?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Ok, I did ask for your code too, so I could adapt it. As it is, this just demonstrates the principle; you'll need to incorporate it into your code yourself

Please Login or Register  to view this content.

Ah, maybe misunderstood this:

Think it might be a VBA code?

You're welcome.




If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.