Mail from userform in excel, content from textboxs and combobox

Hi,
I'm new too vba and have lots too learne, but i need some help with my first "project"

I have a userform i want to mail the textbox content from.
The recipients would i like too use a mail adress from a combobox in the same userform and then represent the data in body.

I have tried but i can only send mail with adress in the code not from textbox.

I have 9 textboxes and 2 comboboxes i my userform.

I hope someone can help me.

Please Login or Register  to view this content.

Can you redact any sensitive information from your workbook and attach it as an example?

To attach a workbook, click the 'Go Advanced' button below and use the paperclip in the toolbar to navigate to your workbook.

I can't test it fully because I don't have excel 2013, but try: Excel%20forum(1).xlsm

Hi perkb

I haven't tested this but you need to loop and send, loop and send...

Please Login or Register  to view this content.

@jaslake,

I can't reopen the file. Somehow it got corrupted. Is that in reference to a mistake I made in coding?

@Solus

Both Files (yours and the OP's) open fine for me.

@jaslake

I meant the edit in the code. Did I make a mistake in my construct?

I was under the impression there would only be one .To = and only one email sent for the most recently updated line.

@Solus

I honestly didn't look at your Code...I simply noticed that the OP's Code appears to be not looping correctly.

If the OP only wants to send the last line updated to one individual why would you need to move Call SubmitEmail()?

Perhaps I'm missing something.

More than likely I am...I only looked briefly at the Code...