This will be an easy one for you Excel programmers out there.
*// WHAT I NEED
A Microsoft Word 2003 .doc file to properly interact with a basic Microsoft Excel 2003 .xls database according to these directions: [login to view URL]
*// WHAT WILL BE PROVIDED
1) Directions: [login to view URL]
2) Sample data below
REQUIREMENTS OF DATA CAPTURED
- 1 Microsoft Excel 2003 database with the below data
- 1 Microsoft Word 2003 document that will output Microsoft Outlook E-mails via Mail Merge whenever I choose to call upon the Excel database
EXPERTISE REQUIRED
- MS Word/Outlook Mail Merge
- MS Excel competent
TIME FRAME OF DELIVERY
By Sunday, November 7, 2010 at 7:30pm Eastern Standard Time (New York City, USA)
ADDITIONAL INFORMATION:
*//SAMPLE DATABASE
AGENT--ACCOUNT--EMAIL
Bob--FakeAccount#1--bob[AT][login to view URL]
Bob--FakeAccount#2--bob[AT]fakemail.c
Bob--FakeAccount#3--bob[AT]fakemail.c
Bob--FakeAccount#4--bob[AT]fakemail.c
Steve--FakeAccount#5--steve[AT]fakemail.c
Steve--FakeAccount#6--steve[AT]fakemail.c
Larry--FakeAccount#7--larry[AT]fakemail.c
Joe--FakeAccount#8--joe[AT]fakemail.c
Joe--FakeAccount#9--joe[AT]fakemail.c
*//SAMPLE OUTPUT EMAIL to [EMAIL]
Hello [AGENT],
I hope you are doing well! May I take a shot at [ACCOUNT], [ACCOUNT], and [ACCOUNT]?
Thank you for your consideration!
Regards,
Doug
_____________________________________________________
*//NOTES
- If the agent has one account, please make the output read: "May I take a shot at [ACCOUNT]?"
- If the agent has more than one account, please make the output read: "May I take a shot at [ACCOUNT] ... ,and [ACCOUNT]?"
- The deliverables are a simple database in an Excel 2003 file and a Word 2003 document that I can re-use depending on changes on the Excel file.