hello everyone! I would like to send emails automatically via excel. The files are from my desktop. I can send e-mails thanks to a macro only if I insert in the cell the pdf link.
I make a table so that the pdf links are created automatically. I have to send a file to everyone. No problem, this is the table of pdf1, it sends well.
As for the second pdf, sometimes I would like to send it to customers, and sometimes not, thanks to a column, or when the value is 1, I would like to add the pdf 2, and not send it if the value is 0.
in the cells of pdf2, I wrote this function ( function if, and concatener)( if append_pdf_2 = 0 I would like a blank ("")
it works when the value of the pdf2 is 1( it thus sends two files to the clients) but it does not work when there must be only one pdf( that is when the value is 0 in append_pdf_2)
Do you have a macro that allows me to correct this error?
here is the macro
I don’t know how to code
thank you very much!!
I make a table so that the pdf links are created automatically. I have to send a file to everyone. No problem, this is the table of pdf1, it sends well.
As for the second pdf, sometimes I would like to send it to customers, and sometimes not, thanks to a column, or when the value is 1, I would like to add the pdf 2, and not send it if the value is 0.
in the cells of pdf2, I wrote this function ( function if, and concatener)( if append_pdf_2 = 0 I would like a blank ("")
it works when the value of the pdf2 is 1( it thus sends two files to the clients) but it does not work when there must be only one pdf( that is when the value is 0 in append_pdf_2)
Do you have a macro that allows me to correct this error?
here is the macro
I don’t know how to code
thank you very much!!