concatenate in vba to send by mail

0

I'm using the ShellExecute function that allows me to open a link from a macro in outlook, I need to be able to read the mail and send the information through a link where a server in php will process it How do I concatenate the x that has the name of pedro to be able to send it in my link?

x = "pedro"
 lSuccess = ShellExecute(0, "Open", "http://localhost/caet/formu.php?nombre=jose&email=correo")

I need that in my php called formu the variable pedro arrives A thousand thanks

    
asked by sanlegas 07.11.2018 в 19:08
source

1 answer

1

The concatenation in VBA is simple

texto_concatenado = "una cadena string" & x

In vba you only use the symbol '&' to join, remembering that the texts that you define are enclosed in quotes and the variables are not.

    
answered by 08.11.2018 в 16:48