Excel Email with Signature

**Mr_Nick666** · 02-24-2014, 11:33 AM

I cannot get the email signature to work when generating an email.

I'd prefer to be able to use rich text as the body of the email is generated from a cell with various CONCATENATEd cell values that show with paragraph spacing.

DON'T send me a bloody link to Rod's page too, as none of it has worked for me!! *tearing my hair out*

Failing the signature thing is it possible to convert my email body cell to HTML?

If I use HTML and just use the cell value it shows as this:

Please Login or Register  to view this content.

when it should look like this:

Please Login or Register  to view this content.

Any ideas?

**JOHN H. DAVIS** · 02-24-2014, 12:36 PM

You can use vbcrlf to indicate a return and go to the next line.

Please Login or Register  to view this content.

If your signature block is not working, you can add it too the body. Probably better ideas, but I've seen cases where the signature block just wouldn't populate.

**Mr_Nick666** · 02-24-2014, 12:42 PM

Thanks.

I can attach my generated body text fine, on it's own, but I wanted to be able to use the default signature, as it has company logos/etc., which is my default Outlook signature.

In the cell I use char(10) to start a new line. It's the switch to HTML that buggers it all up!

I use Office 2010, if it helps.

The code from my body generating cell is

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 02-24-2014, 12:49 PM

I'm afraid I haven't worked with Outlook (I have Lotus Notes). Haven't worked with HTML either, just thought I'd offer a possibility. Maybe someone else can help you.