Action Buttons on Excel

[lbouwer]

Hi All.

I am struggling to put together macros (i have never used VBU and cannot get my head around the syntax.

I need a code that is going to unhide the request quotation button on this sheet unless F2:F7 are Not Null, if any of these fields are blank this will need to be hidden.

Assuming the fields in F2:F7 are infact complete then need this to generate an email to a specific email address, with the document attached, the subject of the Email would be F3 - F2 with the body of the email pre populated with something along the lines of the below

"Good day.

Please can the attached document be issued in line with a formal quotation.

Kind Regards
F4

I am working to a really tight deadline here and would normally spend hours trying to figure this out myself but I am struggling here.

The next step would be the Print button - that would need to print to a PDF with all columns fitting on an A4 page. I havent even managed to look at that yet.

I am desperate here and would appreciate any help/support you are able to offer.

 

[lbouwer]

hi

i dont even know if the above is possible. i have tried recording this as a macro but failed miserably.

Desperate to get this sorted. Any help would be appreciated.