Auto Email Macro - Change

[daveb86]

Hello Guys

I am using the macro below to auto email from Excel

Basically I want to know if its possible to add a message to the body of the email ?

Please Login or Register  to view this content.

Thanks

Dave

[trisoldee]

I had something that would first bring up a Save As window and would then attach the newly saved workbook to an email and bring the email up so you could edit as needed but it doesn't seem to be working anymore. Not sure if this is an issue with excel versions but you can try it and see if it works on yours. If anyone else can figure out why it's no longer working I would also appreciate it.

Please Login or Register  to view this content.

[daveb86]

I had something that would first bring up a Save As window and would then attach the newly saved workbook to an email and bring the email up so you could edit as needed but it doesn't seem to be working anymore. Not sure if this is an issue with excel versions but you can try it and see if it works on yours. If anyone else can figure out why it's no longer working I would also appreciate it.

Please Login or Register  to view this content.

Sorry trisoldee

I already have the code I posted in my initial post which works perfectly ..

Im after a slight change to my code so I can add some text to the email body

Thanks

Dave

[daveb86]

Any ideas how i can add some text to the email body using the macro in my initial post ?

Thanks

Dave

[daveb86]

Morning all

Has anybody any ideas on how I can achieve the above ?

Thanks

Dave

[daveb86]

Or is there a way i can merge the two macro codes below together ?

Please Login or Register  to view this content.

And this one

Please Login or Register  to view this content.

Any help at all would be appreciated

Thanks

Dave