Send Email and Log Date Sent

[dhagar]

Experts,

I am working on a way to use excel to send out an order form on worksheet "Printer Pricing" and am using a drop down list from a second worksheet named "Master Data". The drop down on "Printer Pricing" populates ship to address and other contact information using vlookup referencing "Master Data" for respective fields. I would like to have a button that when clicked sends the "Printer Pricing" worksheet to an email recipient and populates a cell in the row for the selection made with the date the email was sent or button pressed on the "Master Data" sheet.

Is this possible?

Thank you in advance!!

David

 

[dhagar]

I have the email creation process working with no issue using modules from Ron Debruin. Just need to add the small amount of code to populate 3rd column cell of Master Data after I click the process order button respective of the name from list selected.

 

[dhagar]

I hope to simplify what I am asking for. On sheet1 I have a lit that is built made of column A from sheet2. When an item is selected from the list on sheet1 it populates a few fields like address, state, and zip by using vlookup to the data range on sheet 2. All works well. I created a button that takes print area and convert it to pdf then send email. I really need to be able to as a subroutine to clicking the button... not reading from outlook or mail program... add date to column 3 of the respective row of item selected from dropdown list.

Basically when I select the customer and complete order information that is not prepopulated by vlookup then I clcik button to process order. It takes print area and emails add pdf to set recipient. I now just need to add a timestamp in the row of the selected customer to the column label order sent. This way when I look at my customer data on sheet2 I know what day I sent the order for each customer.

Help is greatly appreciated!!

Cheers!