Continuing from previous referenced question and solution (http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28113301.html
1. Even if there are no attachments in the email, I still need the email address, date and Not Yet Assigned inserted in appropriate columns of the record for emails that I click the Save Links button on.
2. For all emails I click Save Links for, extract the first and last name from emailed spreadsheet and paste into Applicant Status.
For Horizontal layout that would be Col A - first name - from emailed spreadsheet goes to Col C in Applicant Status and Col B - last name - from emailed spreadsheet goes to Col B in Applicant Status)
For Vertical emailed spreadsheet Cell B1 goes to Col C and Cell B2 goes to Col B.
3. When I input a x value in Cols: N, P, Q, R and S please have it so the x changes to today's date in the format: mm/dd/year: 05/20/2013