Hi everyone, I am trying to create an automate script to extract excel data to outlook and send out. I have a large excel database with contacts and names of my suppliers and friends. I would like to extract these datas (name, and e-mail address) to outlook and send them a xmas greetings. I would like to design it in a way that it will be able to compose the mail with the following format: Dear xxxx(name from excel): Merry Xmas! That way, every mail is sent with the email address with the respective contact name of the email address. Can have some advice on how to start such script? I am using OSX with Office 2011 Thank you all
Is this a one-time thing? Or do you want it done regularly? If it's a one-time thing, copy the data from Excel, paste it into a Word document and use Word's Mailmerge to create and send the emails. See http://support.microsoft.com/kb/294694
I guess I will do it regularly such as on occasion holidays. I would like to keep in touch with my suppliers and friends regularly and maintain the partnership. I have read a lot online, but I'm not sure am I looking at the correct category. I guess I need to do something with Excel Macro right? Thanks for the reply
By "regularly" I meant every day or something similar. For what you need, use Word's mailmerge. Once you have the merge file - the names and addresses - you just type the letter, then run the merge and it sends the email. The first time will probably take you half an hour or so to figure things out. After that it should be about 1 minute more than typing the letter for that occasion. It's basically a one-click deal.