We often send out emails, where we merge via MS Word and send the email out via MS Outlook. Email addresses and merge fields are made as lists in excel. There are things we cannot do but we would like to handle:
1) Choose which field the email address should be put into (to: cc: or bcc:)
2) Choose the sender email (we sometimes use different email addresses such as "info email address" or others)
3) Choose to automatically merge one email to several people in the to: cc: or bcc: field; E.g. merge MS word text with merge fields from excel and send it out to 3 persons (all written in e.g. to: field). Emails chosen on a criteria in the excel list (e.g. all managers).
4) Attach documents to emails that we merge; It should be done via a link to the individual name in the folder structure on the network e.g. d:\info\test\[login to view URL]
5) Draft merged emails before we send them out
6) Merge fields into the subject field
7) The user interface should be easy to use
8) Program should be integrated with Microsoft word 2007/2010 (MSI package)
9) Able to handle Danish language
10) Code should be commented (future programming)
11) We ownership of the code