Emailing with User Form Contents

[Sun13Banjo]

Hi.

I have a macro that sends an email with an attachment using details in a spreadsheet.

It would be a great help if users were able to enter text into a User Form as part of the macro and have this populate the body of the email.

Everything else is working fine, but I am struggling with this part. Does anyone have any ideas?

Thanks

[davesexcel]

Would it be best to have the email code in the userform? You can still use the worksheet references as well as the userform controls.

Here is a generic email code.
Create a userform with a button and textbox, fill in B1,B2,B3,b4 on the sheet.

Add this code to the command button.

Please Login or Register  to view this content.

[Sun13Banjo]

Thanks davesexcel, this has worked perfectly.