e-mail macro

[Guest]

I currently have a macro set up that will e-mail out different worksheets as
e-mail attachements. Is it possible to change this macro to e-mail out as
the body of the e-mail text rather than an attachement?

 

[Ron de Bruin]

Hi cjmike

See my site for example code and example workbooks
http://www.rondebruin.nl/sendmail.htm

 

[Guest]

Many thanks.

One quick question,

Can you explain this in a little more detail? "Don't forget to copy the
function RangetoHTML in the module."

Many thanks.

 

[Ron de Bruin]

The macro call the function to create the html in this line

.HTMLBody = RangetoHTML(rng)

If it can't find the function it is not working
Copy both in a module and run the macro

http://www.rondebruin.nl/mail/folder3/mail2.htm

 

[Guest]

Many thanks.

One other question, if I add pictures or shapes to the worksheet these do
not come through with the e-mail. Is there a way round this?

 

[Ron de Bruin]

Hi cjmike

Read the more Information part below the macro on my page
http://www.rondebruin.nl:80/mail/folder3/mail2.htm

 

[Guest]

Many thanks.

Hi cjmike

Read the more Information part below the macro on my page
http://www.rondebruin.nl:80/mail/folder3/mail2.htm