Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba,microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel as a data source for Outlook to email Word docs
Hello
Each fortnight I am given a report (in Excel) containing the details of all NEW team leaders and managers for our organisation. This report contains, amongst other things, the User ID and First Name of each person listed. I also have a standard letter (in Word) which needs to be emailed (via Outlook) to each of these people. WHAT I NEED In summary, I need a macro which will do the following: 1. Grab the first name of the person from the Excel spreadsheet and place it in the salutation of the letter in Word (i.e. Dear "first name") 2. Send this letter as an attachment in an email via Outlook, which in turn uses the User ID from the Excel spreadsheet as the email address. My preference would be to have a separate email for each person listed in the spreadsheet, and for the macro to process each name one by one until it hits a blank cell. If at all possible, I would also like to have the person's first name used in the actual email text. As such, I imagine the macro (or macros) would have to save the Word document with some sort of unique name (perhaps using the User ID in the filename) in a particular location before then using Outlook to open an existing email template, inserting the first name in the email text, attaching the appropriate letter and then sending it off to the correct recipient. Basically, we are trying to create a personalised experience for these people. I have cross-posted this to a group in each of the three applications (Excel, Word and Outlook) as I wasn't sure where to start? Any help would be greatly appreciated. I really hope this is possible... Joe. -- If you can measure it, you can improve it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA toggle Outlook '03 Word email editor on/off | Excel Programming | |||
Creating Word Docs from Excel Data | Excel Discussion (Misc queries) | |||
Import cells from excel into word and create multiple word docs | Excel Programming | |||
Embedding Word Docs into Excel Worksheets and Then Printing The Word Docs | Excel Worksheet Functions | |||
converting excel docs to word docs | New Users to Excel |