Recent content by capemem

OK. Thanks for all your help. Very much appreciated.

Brilliant That solved it straight away. The only issue I have now is that when the email opens in Outlook, it is blank and does not have my signature which is usually there when I open a new email.

OK. Have managed to get the first email address in my email by using MyMail.BCC = strMailList after amending the code to look like this however, it only puts in the first emai address even though it appears to be looping through them all. Any ideas? ' Now, we open Outlook for our own...

Hi This does seem to enable putting addresses into the BCC field but only if I type them in as you have done. Is there a way that I can put in all the email addresses in a similar way that the previous line does: MyMail.Recipients.Add MailList("email") Then I could get rid of this line and...

Hi It was with that bit of code. I have tried the new bit also and it still comes up with an error on that line. The error is a Run-time error '438': Object doesn't support this property or method. Thanks again for your assistance. It has been driving me crazy for 3 days.

Thanks for replying. I have tried your suggestion and also the code in the microsoft article and neither seem to work. Keeps coming back with a runtime error. Any other ideas? Thanks for your help.

Hi I have hijacked a bit of code to facilitate grabbing a whole lot of email address from a table and put them into an email. I have modified the code so rather than create a seperate one for each email address they all go into one email. The problem that I have is that they all go into the...