Include Signature in Auto emailing code

[hegartyjp]

I have written a few systems which email lists of people with specified attachments. I am using VB through excel to send mails with Outlook. Does anyone know if there is a way to include the users signature which is stored in outlook on the emails

 

[VBAjedi]

A while back I was doing some similar email generation and dug around for a way to include the users sig. I never did find anything, so I ended up using text from a cell on an "Admin" worksheet. That way the sig doesn't have to be hardcoded, and users can change it to suit themselves.

You just have to add code that converts any CHR10 (Excel's in-cell line wrap character) to CHR13 (a standard Return character). I've got a function to do that if you decide to go this route.

Let me know if that's helpful!

VBAjedi

 

[hegartyjp]

Thanks for your reply. It doesnt actually serve what I require to do but I appreciate the response