Excel Button Macro does not work when excel s converted to PDF

[SpreadsheetMM56789]

Hello!

Please excuse if these questions aren't very advanced... I'm very new to VBA/macros.


--I had the goal of creating a button in excel one would click/confirm that would automatically send an email (to me).

--I learned how to do this (although it is by using outlook... does anyone know if there's a way that one can click the button and an email is sent using whatever email client the person clicking the button uses? Bascially... i am sending a document to a number of people and want there to be a "confirm" button that automatically sends me an emailing confirming they received the document/message).

--my second issue however (after learning how to send the email using Outlook..for now) is keeping the button intact when converting the excel doc to a PDF. Ideally, my document is to be created in excel, incorporated with a "confirm" button that sends me an email, but the document is in PDF form.

Apologies if this a bit (or a lot) obtuse... any guidance is much appreciated!!

[Keebellah]

Hi welcome to the forum.
About the PDF, this is no longer Excel so that functionality is lost the moment you create a PDF file.
For the other question, yes you can send a mail using the default client, google and seach on Ron de Bruin's site, he has some code snippets there.

[dotchiejack]

It is easy to add a send button in pdf, it is a inbuild feature but you need acrobat pro DC (not the reader) to make a entry form with send button.
If you don't have acrobat pro, post the excel file or the PFF file and I'll can make a fillable entry form with send button for you.

[Keebellah]

@dotchiejack: I'm not that knowledgeable with Acrobat but if you have a hyperlink on the file, will that work?

[dotchiejack]

@ keebellah
You can code it in java that certain text in the PDF acts as a hyperlink but with the inbuild feature (mailto function) ,you only have to add the mailaddress.

[Keebellah]

Okay, thanks for the answer; I was just curious,

[dotchiejack]

Something like this maybe ?
There is a free plan.
https://www.emailmeform.com/