Emailing

[#1]

Hi

Im using macro to send Excel files through email

the problem is appeared , when the email id is incorrect and it stops there

In such cases i want to move to next emailId.

How can I jump to next email Id record when the previous is incorrect

In short I want to identify the correct emailId and inCorrect Email ID in ???

[#2]

can u send the Macro code?

[marcus_sommer]

You should check the mail-adress before you run the send statement and if false take the next mail:

If(len(mail)) > x and instr(mail, "@') > 1  .....

Also you could tried with "On error resume next" or react on a specific error message.

- Marcus