New to VBA (or any coding), making a macro to auto generate an email, could use help.

Hello all, fair warning, I did also ask this on MrExcel but received no answers. Hoping to get some results here!

I have the code below that I butchered from rondebruin.nl but I'm hitting some road blocks. I'm on day 3 of attempting anything like this and I think I'm just confusing myself the deeper and deeper I get. I'll sum this up the best I can.

What this code currently does: Opens a new email with the BCC field filled out. The subject reads "RFQ: ". A copy of the worksheet is attached.

What I would like to be added/fixed:
1. Use the part number column to auto populate the rest of the subject line. So it would read "RFQ: Test Part, Test Part 2, Test part 3....
2. Only have the portion of the spreadsheet that's filled out to be copied. There's no need to copy blank rows
3. Insert signature at the end of the email
4. Attach files from a shard network drive. The file names are always "PARTNUMBER_Rev#" and will always be a .PDF and .IGES file. Sometimes there will be two different .DWG files

I feel like I'm asking for a pipe dream here. As a company we send out a lot of RFQ emails and I was hoping to automate the process more, but this is proving to be very difficult for me

Please Login or Register  to view this content.