hi guys

i am fairly new to vba but i am trying to make a stock management system.

i have a userform setup that successfully takes data entered into various textboxes and pastes the values into the next empty row of a worksheet

now i want i am trying to add a command button that once pressed takes all new entries to the sheet copies them into an email and then sends it.

it does 90% of what i am trying but it just wont copy the selected cells into the email.

Could someone please shed some light as where i might be going wrong.

Thanks in advance 

Please Login or Register  to view this content.