"Moving" Macro

[locopete999]

Hi Guys,

Not sure if this would be something that works, but wanted to sound it out.

Say for example I had a list of 10 numbers in column A.

In column B I have a list of 10 e-mail addresses.

For the sake of this, say I know how to get excel to e-mail Address B1 with detail A1.

Would there be a way to programme a macro that would repeat this for each line in A1, either until there is no more information or for a set length (10 rows)?

Basically I want to be able to have a macro that would repeat for each line in a sheet.

[BellyGas]

Yes.

A lot depends on your email client, ie the code for sending emails via Lotus Notes will be different to sending via Outlook. Assuming it's Outlook you're using have a look at: http://www.rondebruin.nl/win/s1/outlook/mail.htm

[locopete999]

Hi Bellygas,

I know how to e-mail it out.

I'm just not sure on how to get a macro to repeat for each different line.

[AB33]

You loop through each column B cells and use that cell as e-mail address. You can also add column A for anything else.

So,

For each cel in range("B1:B" & range("B"&rows.count).end(xlup).row)
cc: cel

next