Excel 2007 :: Finding Code To Enable Emailing Items On Spreadsheet

Need a code that sends emails to the intended receipients based on hold codes if Columnd J reads as YES Email formats are listed on "Email Format" tab, code should pick the required field value from the table (Hold Report).

Analyst name, Phone number are entered in the text boxes (data validation for these is desired)

option boxes are used to send email based on the selection as below

if "send initial email without attachment" is selected then emails should be sent without the attachments

if "send initial email with attachment" is selected then emails should be sent with the attachments

Attachments are usually .PDF files and are stored on users desktop with file name as .pdf

if the follow up otion is selected the subject line on the mail should be appended as *** 1st Follow-Up*** along with standard subject line

Rest of the requirement remains same for followup option (same email format is used) based on the option selected, code should be able to send emails with or without attachments. I have provided three command buttons that are intended to work as follows;

Validate data: need to validate the data to ensure that each row has atleast one email address in "TO" column and there are no spaces in the email address.

Clear Data: Should clear the existing data from the table

Send Emails: Should send emails

Standard subject line is a combination as below

Invoice on Hold for ; Invoice number: ; PO Number: ; Invoice Amount:

Note: Column H and I apply only for hold codes Qty Ord and Max Ship Amount

I use Microsoft 2007.