Excel Macro HELP NEEDED

pujo · 11-22-2008, 12:10 PM

Hello all.
I need a little help here.
I am using Excel 2003 & Microsoft Office Outlook 2007

I want to take a selection of cells from my spreadsheet and insert them into an email message body, either as an image or what ever is easiest. It is for reference only.

I want to use cells A5:K32 and email it. I don't need to save the selection of cells just email them. I have tried numerous times using different code from different places and I just can not get it to work. Some even crash Excel!

So A5 threw K32 needs to be emailed to 2 addresses only.

I have been working on this for 4 days now and haven't found anything that works.

Please lend a hand if you can.
Thanks in advance,
Pujo

ratcat73 · 11-22-2008, 07:08 PM

G'day

Does this help ??????????

http://www.rondebruin.nl/mail/folder1/mail4.htm

pujo · 11-23-2008, 04:14 AM

That particular code locks up excel and restarts it.
It would be great if that would work.

I am using the Add-In SendMail and it works, I just wish I could make a few changes to it. Like removing options and make it select a range of cells and a few other things.

Thanks,
Pujo

ratcat73 · 11-23-2008, 04:25 AM

Just thinking out loud.......

I'm not a big user on macro and add in, but there maybe conflict between the macro and the Add in.

Disable the add in and see if the macro works without any bugs.

pujo · 11-23-2008, 04:28 AM

I was trying the code prior to installing the Add-in.
I will try again.

Thanks,
Pujo

pujo · 11-24-2008, 04:31 AM

Thanks to Mr. Ron de Bruin,
Everything is working fine.

Thanks to everyone,

Pujo

11-22-2008, 12:10 PM	#1 (permalink)
pujo Registered User Join Date: Nov 2008 Location: Gulf Of Mexico Posts: 10 OS: XP	Excel Macro HELP NEEDED Hello all. I need a little help here. I am using Excel 2003 & Microsoft Office Outlook 2007 I want to take a selection of cells from my spreadsheet and insert them into an email message body, either as an image or what ever is easiest. It is for reference only. I want to use cells A5:K32 and email it. I don't need to save the selection of cells just email them. I have tried numerous times using different code from different places and I just can not get it to work. Some even crash Excel! So A5 threw K32 needs to be emailed to 2 addresses only. I have been working on this for 4 days now and haven't found anything that works. Please lend a hand if you can. Thanks in advance, Pujo

11-22-2008, 07:08 PM	#2 (permalink)
ratcat73 Registered User Join Date: Oct 2008 Location: Australia Posts: 51 OS: Vista Home Basic	Re: Excel Macro HELP NEEDED G'day Does this help ?????????? http://www.rondebruin.nl/mail/folder1/mail4.htm

11-23-2008, 04:14 AM	#3 (permalink)
pujo Registered User Join Date: Nov 2008 Location: Gulf Of Mexico Posts: 10 OS: XP	Re: Excel Macro HELP NEEDED That particular code locks up excel and restarts it. It would be great if that would work. I am using the Add-In SendMail and it works, I just wish I could make a few changes to it. Like removing options and make it select a range of cells and a few other things. Thanks, Pujo

11-23-2008, 04:25 AM	#4 (permalink)
ratcat73 Registered User Join Date: Oct 2008 Location: Australia Posts: 51 OS: Vista Home Basic	Re: Excel Macro HELP NEEDED Just thinking out loud....... I'm not a big user on macro and add in, but there maybe conflict between the macro and the Add in. Disable the add in and see if the macro works without any bugs.

11-23-2008, 04:28 AM	#5 (permalink)
pujo Registered User Join Date: Nov 2008 Location: Gulf Of Mexico Posts: 10 OS: XP	Re: Excel Macro HELP NEEDED I was trying the code prior to installing the Add-in. I will try again. Thanks, Pujo

11-24-2008, 04:31 AM	#6 (permalink)
pujo Registered User Join Date: Nov 2008 Location: Gulf Of Mexico Posts: 10 OS: XP	Re: Excel Macro HELP NEEDED Thanks to Mr. Ron de Bruin, Everything is working fine. Thanks to everyone, Pujo