Excel Mass Email

[Jill]

Does anyone know of anyway or program to do the following:
We have Excel file that contains 3 columns- ID, password
and email address. We need to email each ind email address
their ID and password. Is there a program that we can use
that will do this email merge? Thanks!

 

[Ron de Bruin]

Hi Jill

Try this example on my site
http://www.rondebruin.nl/mail/folder3/message.htm

 

[Guest]

Hi Ron, thanks for the info. I tried to copy this into my
Test sheet and I receive an error that the User Defined -
type not defined- "Dim OutApp As Outlook.Application"?

-----Original Message-----
Hi Jill

Try this example on my site
http://www.rondebruin.nl/mail/folder3/message.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jill" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

Hi Jill

Read good

On top of the page

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

Or use Late binding (also on the same page)

 

[Mike A]

Be careful - don't accidentally attach the file to the e-mails!


Mike Argy
Custom Office solutions and
Windows/UNIX applications