"Type mismatch"-error with a short test-version of mail macro

**JohannesEngelbert** · 02-14-2010, 10:13 AM

Hi all,

I have made a mail macro for my work, but my collegues would like to see a short testversion of the macro, to see that it gets up all the good information from my sheet and that there are not too few/to many spaces. My intention is to create a macro that opens two "new e-mail" screens in Outlook, with one Dutch and one English version of the mail. But when I run the test version, it says "type mismatch". What am I doing wrong? Below my mail macro and my test version. Thanks.

Full mail macro

Please Login or Register  to view this content.

Test version

Please Login or Register  to view this content.

**martindwilson** · 02-14-2010, 10:32 AM

im not sure but i think
Dim cl As Range
is needed then again that may be gibberish

**JohannesEngelbert** · 02-14-2010, 10:50 AM

I've added it to the code, but it keeps saying "type mismatch".

**DonkeyOte** · 02-14-2010, 11:05 AM

A few pointers perhaps:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

You should also look to restrict the range you're looping to include only those cells necessary... as is you're going to iterate every cell in Column E...

Explicitly Declaring variables (as outlined by Martin) is good practice if not always required.

**JohannesEngelbert** · 02-14-2010, 11:55 AM

Thanks, the macro runs now, but not correct. He opens a new e-mail for all the adresses in column E, but in every mail the body is only "contactperson", he skips the rest of the mail.