I need a way to insert text into an automatic email prior to sending. What I have now is a macro that when executed sends a message which can not be modified without altering the macro (the current message is "box XXXX has been picked up") and an attachment of cell A1. What I need to do is modify the macro to be able to put in a lot # into the message. The lot number will change daily. I was hoping for one of two solutions:
1-a dialog box pops up and asks for the lot # which would produce a message that says "box # XXXXX has been picked up" with XXXXX being the lot number.
2-we track the lot # in the same spreadsheet as the attachment is created from. If it could search a range and then automatically insert the last number in the range that would work too.

thanks for your help.