PDA

View Full Version : Email multiple worksheets - help please?



bspires
11-08-2007, 02:31 PM
Hi Guys,

I hope you can help me.
I'll apologise now, I don't have a lot of VBA experience....I did a bit at uni a few years back but it hasn't come flooding back to me :(

I have got a macro that imports 4 csv files into excel (onto seperate sheets) and formats / filters the data. This is done twice daily so the data is always different.
The data is formatted to Name, Ref number, Summary, Date, Date Modified onto each sheet.
What I need to do, is email the 4 worksheets, to recipents named in column A of each sheet with a piece of standard text in the body of the email, and manually enter cc recipients. Can anyone please help. I'm getting a big headache trying to figure this out.:banghead:
The Name is currently formatted as Joe SMITH - therefore will need a comma or semi-colon to seperate it for the Global Address List in Outlook, and the names will change daily so can't hard-code them.

Please help me.

Many Thanks in advance
Ben