I'm new here, so apologise if this has already been asked/answered before.
I use Office 200.
I would like to send an email message to a supervisor when a user
completes an order and pushes a button. The email needs to include
some data relating to their order, all found on one row.
The recipient is selected by the user from a dropdown list,
and this will always be on the row of the last entry.
I need to extract some data from the same row, and add the data to
the body of the message.
eg Item, Date Ordered, Lab or Plant, ETA, etc. I can do this part.
(The subject will always be the same, eg "You Have A New Order".)
At present when I use:
it sends the active workbook as an attachment.
(I used this previously, and it worked fine.)
Does anyone know how to send just an email with recipient,
subject AND body text, but WITHOUT an attachment?
Thanks in advance