Hello.

I've created a workbook with apprx 15 sheets that gathers data/info from various spots off of webpages. I then have each sheet format and basically "clean" them up. Now I'm trying to compose them into an email / document.

I have found many vba scripts that will take a sheet and post the contents in the body of an outlook mail in html format. This works, but it will only do 1 sheet. I have played around with editing it and have it so it will do 2 sheets, but on the 2nd sheet the format is lost (colors, font, etc).

What I'm after is a simple way to add sheets in a specific order into the body of an email or even a document -- that can then be copied to email.
Some of my sheets contain pictures and some are just tables with text. I've worked out all of the active areas so I've been just using 'ActiveSheet.UsedRange.Select'.
I know the simple answer is to merge the sheets into 1, but I have issues with spacing (width / height for rows and columns different on most sheets).

Basic ideal is:
workbook contains 'sheet1' 'sheet2' 'sheet3' 'sheet4' etc.

macro -> creates email -> Inserts 'sheet2' into email, Inserts 'sheet1' into email, Inserts 'sheet4' into email (yes they are out of order on purpose)

Any help or ability to point me in the right direction is better then where I am now. I'm not an expert vb person, but I've been playing for awhile now. I did not attach my code as it is all clipped from the web. I'm open to start from scratch

Thanks