E-mail to every e-mail address in an Excel column?

[Guest]

Yes! That's the solution! I would not have figured that out without your
assistance. It got so that I cut and pasted the macro (with MY specifics)
onto a Word file so I could cut and paste it into the VBE each time! When I
read Ken Wright's instructions
again (which are VERY clear), he tells me to save the spreadsheet!! Oh
well!! Thanks for all your help and the help of all you gentlemen. The macro
is AWESOME!

 

[Don Guillett]

glad to help

 

[Guest]

When I try the second macro (i.e., the one that will send one email with 1
address, I get the error "User defined type not defined" and this line is
highlighted: "Dim Outapp as Outlook.Application". Any ideas? P.S. What does
"Dim" mean? Thanks.

 

[Ron de Bruin]

Hi MrMan&Fam

You can read this on the webpage

You must add a reference to the Microsoft outlook Library.

1) Go to the VBA editor, Alt -F11
2) Tools>References in the Menu bar
3) Place a Checkmark before Microsoft Outlook ? Object Library
? is the Excel version number

 

[Guest]

Hi there, I'm using your code you posted here. And it works when tha data in
column C are plain e-mail adresses. But problem is that my adresses in column
C are "=concatenate(A1;B1)", so they are result of a formula. What should I
change in the code to make it work? I'm not very familiar with VBA.
Thanks.
Milos


Ron de Bruin píše: