Good evening everyone,
I wonder if there are some VBA people that like a challenge!
I am trying to find a way to copy a range, save it as a .pdf, open outlook, send email to recipient and message, copy ranged contents place onto another sheet as a list (ie next row down from previous entries) then blank range ready for next order
Big, big ask I know
I have tried the macro-recorder but it seems to miss out the outlook part
So, if possible I need the following at the click of a button
1. Copy Range A7:K74 from "orders" worksheet
2. open outlook
3. Send Copied range only as a pdf attachment named "Purchase order" to recipient with CC to another recipient with message "Purchase Order Attached"
4. Copy Range C25:I68 and paste as values only on worksheet "Received" beginning from C9 (Next order to go under this order etc)
5. Back to "Orders" worksheet C25:C68, E25:E68 and I16 to be cleared ready for next order,
6. select A1
Many thanks for any help
I wonder if there are some VBA people that like a challenge!
I am trying to find a way to copy a range, save it as a .pdf, open outlook, send email to recipient and message, copy ranged contents place onto another sheet as a list (ie next row down from previous entries) then blank range ready for next order
Big, big ask I know
I have tried the macro-recorder but it seems to miss out the outlook part
So, if possible I need the following at the click of a button
1. Copy Range A7:K74 from "orders" worksheet
2. open outlook
3. Send Copied range only as a pdf attachment named "Purchase order" to recipient with CC to another recipient with message "Purchase Order Attached"
4. Copy Range C25:I68 and paste as values only on worksheet "Received" beginning from C9 (Next order to go under this order etc)
5. Back to "Orders" worksheet C25:C68, E25:E68 and I16 to be cleared ready for next order,
6. select A1
Many thanks for any help