Emailing from Excel

[Pekkavee]

I just became a member of the board of a Finnish Touring Motorcycle Club.
I have a BMW R1000 GS which is a wonderfull bike.

My responsibility is to take care of the member list and some info to the members.

How can I send Email to all the members, if I have their Email Address in column A in Excel. I am using Eudora in this case. Outlook could be possible as well.

Regards
Pekka

 

[new2leeds_com]

It is checked in Excel as well

So thats not the problem. Good thinking though, I hadn't checked.

 

[Pekkavee]

Well I have

Outlook 2002 and
Excel 2003

Maybe there is some problem between the versions.

Pekka

 

[new2leeds_com]

Gonna install Office 2003 and see if that fixes it.

 

[Pekkavee]

Gonna install Office 2003 and see if that fixes it.

Before doing that I think you could use this " late binding" method:



Late Binding



If you don't want to set a reference then you can use late binding.

This avoid problems when your workbook is used in different excel versions.



See ****'s site for a explanation
http://www.dicks-clicks.com/excel/olBinding.htm


Replace this three lines



Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem

Set OutMail = OutApp.CreateItem(olMailItem)



With this three



Dim OutApp As Object
Dim OutMail As Object

Set OutMail = OutApp.CreateItem(0)

Explained in here: http://www.rondebruin.nl/mail/folder3/message.htm

Pekka

 

[xcdave]

I was running into the same problem. I fixed it by adding "localhost" to CreateObject:

Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application", "localhost")