VB Person needed

buntykins · May 20th, 2002, 08:06 AM

Hi there,

I have some VB code designed to write an email. It works great, but I'd like to put a separate line in the body of the mail. The code I am using for the body is:

.Body = "Thank you for your quick reply"

I have tried putting another .Body line in underneath but it only accepts the latter one. I have also tried putting '& "Yours Sincerely...' but it just tacks it onto the main body line.

Can anyone help?

Mark O'Brien · May 20th, 2002, 08:08 AM

How about something like:



.Body = "Thank you for your quick reply" & vbNewLine & "Yours Sincerely..."

Use "& vbNewLine" to start on a new line.

HTH

buntykins · May 20th, 2002, 08:16 AM

You hero, thanks Mark

xxxxx

May 20th, 2002, 08:08 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	How about something like: .Body = "Thank you for your quick reply" & vbNewLine & "Yours Sincerely..." Use "& vbNewLine" to start on a new line. HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 08:06 AM	#1
buntykins Board Regular Join Date: Apr 2002 Posts: 76	Hi there, I have some VB code designed to write an email. It works great, but I'd like to put a separate line in the body of the mail. The code I am using for the body is: .Body = "Thank you for your quick reply" I have tried putting another .Body line in underneath but it only accepts the latter one. I have also tried putting '& "Yours Sincerely...' but it just tacks it onto the main body line. Can anyone help?

May 20th, 2002, 08:16 AM	#3
buntykins Board Regular Join Date: Apr 2002 Posts: 76	You hero, thanks Mark xxxxx