Manieldunk
New Member
- Joined
- Apr 4, 2017
- Messages
- 3
Hello,
I have a work sheet (Excel 2007) with a few buttons that generate emails based on certain cell values. When clicked they sort by a specific date in a column then by customer name. It uses the customer name to grab email address from a separate sheet "Mailinfo" and then it generates an email with the correct addresses using an outlook 07 template. The functionality works for 3 out of 4 buttons.
I am having trouble with the 4th button "Notify Cust of Estimated Ship Date."
I need the macros to take data from two separate columns (D & J) "Order Number" and "Estimated to ship." (If column K has today's date in it, then I need the email outlook template to include the data from the cell D & J, preferable as normal text but a picture would also work)
Currently I can only get it to work by taking a picture of the cell range (D1:J) and inserting it into the template. The problem is I do not want the cells E to I included in the email. Other people have been using this sheet for many years so I am trying to avoid rearranging the columns and screwing up their work flow.
Note: Use link to view the project on One Drive, For it to work all files need to be in the same folder called "PO Log 2017."
Link to the excel stored on OneDrive: https://1drv.ms/f/s!AsRJX032370olTrY4sH433jLr5aH
Any help will be greatly appreciated.
I have a work sheet (Excel 2007) with a few buttons that generate emails based on certain cell values. When clicked they sort by a specific date in a column then by customer name. It uses the customer name to grab email address from a separate sheet "Mailinfo" and then it generates an email with the correct addresses using an outlook 07 template. The functionality works for 3 out of 4 buttons.
I am having trouble with the 4th button "Notify Cust of Estimated Ship Date."
I need the macros to take data from two separate columns (D & J) "Order Number" and "Estimated to ship." (If column K has today's date in it, then I need the email outlook template to include the data from the cell D & J, preferable as normal text but a picture would also work)
Currently I can only get it to work by taking a picture of the cell range (D1:J) and inserting it into the template. The problem is I do not want the cells E to I included in the email. Other people have been using this sheet for many years so I am trying to avoid rearranging the columns and screwing up their work flow.
Note: Use link to view the project on One Drive, For it to work all files need to be in the same folder called "PO Log 2017."
Link to the excel stored on OneDrive: https://1drv.ms/f/s!AsRJX032370olTrY4sH433jLr5aH
Any help will be greatly appreciated.
