I have a word template document which I have to email to the same recipients time and again. I would like to do the following with one click:
1. Create a subject line from the first line of the word document
2. Create a body for the email from the entire word document, excluding the first and second line of the word document
3. Open a new mail item in Outlook, the new mail item should have the following properties:
a. Two predefined recipients
b. One predefined recipient in the BCC field
c. The subject propagated from the word document
d. Insert the text from the word document into the body above the default signature
e. Open the attachment dialog box to a specified folder, the folder is chosen in accordance with the subject of the email
I have already done the majority of the work however I seem to have problems with formatting, etc.
A sample letter is attached.
More detailed instructions will be given either verbally or by text
27 freelancers are bidding on average $115 for this job
Hello, I am very much interested to do this work as i have strong knowledge on writing VBA. Looking forward to have a positive response from you. Thanks
Dear sir, I'm an experienced Excel/VBA developer and am eager tomcomplete this job properly and in time. Please provide me some more detailed instructions.
I will develop the vba code according to your specifications, and test it and discuss with you if everything is according to expected. I will make any corrections if needed, for free.