How to insert space lines in mail body content on a macro

**nomis6565** · 11-18-2012, 01:34 PM

Hi,

I would like to had some space lines in my email body text on a macro and add the name located on F9 at the end of the text.

Here is my code:

Please Login or Register  to view this content.

Here is the way I'd like it to appear in the email body:
Bonjour,

Veuillez svp signer les DEUX pages du formulaire en pièce jointe et me le retourner afin que nous puissions procéder le contrat de prêt d'équipement.

Merci!

Name(Range F9)

Thanks in advance,
Simon

**MarvinP** · 11-18-2012, 01:43 PM

Hi Simon,

There are VB constants to do this. I think you are looking for "vbCrLf" to insert into your string.
Like:
strBody = "Bonjour, " & vbCrLf & "veuillez svp signer les DEUX pages .....

see http://support.microsoft.com/kb/211774

**nomis6565** · 11-18-2012, 02:06 PM

Dear Marvin,

Thanks for your quick response! Right what I needed!
Here is my final code and how it appears on the mail body. I'm just wondering why the is no space line after "BONJOUR" like it does between the message and the name at the end?

Please Login or Register  to view this content.

Here is how it appears on the body mail:

Bonjour,
veuillez svp signer les DEUX pages du formulaire en pièce jointe et me le retourner afin que nous puissions procéder le contrat de prêt d'équipement.

Merci!
Simon Larin