-
Email multiple worksheets - help please?
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.
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules