vb Code

  • Thread starter Thread starter Excel Help!
  • Start date Start date
E

Excel Help!

I have the following code in my macro; however, I wish to place a space
between two fields: FirstName LastName. The data prints out
"FirstNameLastName". Thanks for any help.

..Body = "text" $ cell.offset(0,-1).Value &
cell.offset(0,-2)&vbNewline&vbNewline&_
 
Perhaps this...

..Body = "text" $ cell.offset(0,-1).Value & " " &
cell.offset(0,-2)&vbNewline&vbNewline&_
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joining 2 modules as 1 for email with Excel 1
VBA Email Cell Contents When Filled In 4
Combining Procedures into Loop 3
Help me insert a table of data into a body of an email 1
Add cc option to Send Mail + attachment 8
mailing from excel - For each cell - already in use - error 3
add an inventory item to a word doc if there is a Y in column C 2
How to get e new line in html email (Ron De Bruin's code) 6

Back
Top