Email Out of Excel Code no longer working due to update or drive change.

Hi All,

We've had a macro for years, which pulls information from the sheet the macro is embedded in, pastes it into a new sheet and them emails the data via outlook to people within the defind list. The code was written by someone who is no longer in the business, and whilst I have a grasp of VBA I can't understand why it can't find email out the report anymore.

We have had two changes which I feel could have impacted this, firstly there are changes in the drive location listed in the macro. Although I'm almost certain these have been updated correctly. Secondly we have updated to Excel 2007 (still on outlook 2007).

The code is

Please Login or Register  to view this content.

and it falls down at the point where it is selecting the email addresses in the routingslip. (It's stating that the email address is not recognised, whereas I can see it is in the locals window?

This code has worked for years, so want to know if a) there is any obvious errors to anyone, b) if I need to do anything to excel 2007 to allow it to do this?

Thanks for any help on this one.

Best regards
Carl.

Just to add in the code the DDSO_Email list usually goes up to 40 (not 5) I've just had to remove 35 of them to fit in the post.

Thanks again.
Carl

I can't see anything wrong with the code so can only give general guidelines.

Firstly, make sure you have Option Explicit at the top of the module in which the code resides. Then compile and fix any errors.

Then comment out all the On Error statements as these might be hiding the cause of the problem and step through the code in the VB editor (press F8 on each line).

Thanks for the response.

Will work through it again without the error statements and see where I get to.

Not sure what option explicit is though? Could you explain a little for me?

Thanks

Also we have just checked again with an older computer and 2003 excel!

These work in 2003, so it has something to do with the upgrade to excel 2007 (outlook is still 2003). Any suggestions?