generating emails from excel fields
I'm wondering if anyone can direct me to an excel macro that generates form emails from the fields of a spreadsheet. This should be pretty simple, but I'm trying to save time by working from a template. The only thing I'm not sure how to do is make it look up the recipient's name in my firm's global address book. Any help would be appreciated.
Thanks,
Zach
Generating Emails from Excel Fields
Zach -
I don't know much by question...
Here's what I've done...
I'm using a Dell Laptop with XP
Microsoft Office 2007
I have a spreadsheet that has several columns:
User
User email
Moved From Room
Moved To Room
Blah blah blah...
If you go to Word - on the ribbon you will find the option for "Mailings" - select that tab and you will see the ribbon offers "Start Mail Merge" - I like to use the step-by-step wizard...keeps me on track...
You can save the document as a template if you wish...
Here's the deal...
Using the wizard it will ask you where to obtain the email addresses - and you select the option to browse - choose the Excel spreadsheet that has those fields you want to merge - and the you can put them any where you want in the Word document...
I hope that I'm being clear - sort of hard to explain without pictures (LOL)
-- Jae
Quote:
Originally Posted by zach
I'm wondering if anyone can direct me to an excel macro that generates form emails from the fields of a spreadsheet. This should be pretty simple, but I'm trying to save time by working from a template. The only thing I'm not sure how to do is make it look up the recipient's name in my firm's global address book. Any help would be appreciated.
Thanks,
Zach