Help with macro not working - Pull from fields > attach doc from folder > send email

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 D7:D8 - 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.

A sample (non sensitive) will be great. It is doable!!!

Oh wow, that's great to hear!

I've added a link to the worksheet & I've removed any sensitive info. Also, I've included the macro code to my original post.

https://app.box.com/s/wrpxoigkpy9x1502h6t0

Here is the macro code as well:

Please Login or Register  to view this content.