Yikes - I hardly know where to begin -

I need help getting this macro to work -

In this worksheet I need to be able to input values in E1 - E6

(Subject) E1: Value from Vendor Name Column

(Body) E2: Will be copy pasted text

(Start Row) E3: Row number of first vendor entry to start with

(Last Row) E4: Row Number of last vendor entry to start with

(CC
Email
Addresses) E5: Single string of all the email addresses - separate addresses with a semi-colon

(From
Address) E5: Sender's Address



We need to be able to enter an appropriate value in cells E1: E6 - and upon selecting the "Create Draft Email" macro button currently occupies D78 - show an outlook message appropriately prepared for sending.

Also (not sure how this would be accomplished) - there is a folder path where there will be documents stored by Vendor Name:

C:\Users\SERGIL\Desktop\VATS

I need to somehow incorporate the ability to have the macro search by name (to be entered in cell E7?) for the .pdf / .doc / .xlsx entered in the cell - and have it automatically added as an attachment to the prepared Outlook email.

2 questions:

(#1) Is this possible?

(#2) How would I go about sharing the worksheet (containing the macro as developed thus far) securely to be helped?

Any & all help is GREATLY appreciated

I'm an idiot - but I try my best to be descriptive, at least.