Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatinate and skip a line

Status
Not open for further replies.

aw23

Programmer
Nov 26, 2003
544
IL
I have a list in Excel of names and email addresses. I need to email an email with an attachment to each one. I know this is simple, I have done it before. However I have a question. I am creating the body and I am creating a variable where I can set the name of the person I am sending the email to. I can then concatinate it but when concatinating how can I create a blank line? (press enter twice?)

Thanks
 
aw23

If you use chr(13) it will add a Carriage Return combine a few of then to give blank lines in the body text.
 
I figured it out, in case anyone else needs it, it's
vbCrLf

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top