I need someone to write some VBAs for Microsoft Office suite. The below are the objectives and specifications.
We received some reports sent to MS Outlook as attachments in emails, in text (.txt) files. Each email has one report. We receive many of such reports a day. I want a macro to automatically save all these .txt file into pdf. One report one pdf file except for that in some cases a few reports should be combined into one pdf file. Our outlooks do not have pdf add-on so you may need to use Word to convert the files to pdf. We are on Office 2007.
For those files that need to go into one pdf. The would be based on the names of the files. For example, HKPB123 and HKPB243 go together.
After generating all these pdf files and save them into a designated folder. The macro would then move all these emails in Outlook to another folder.
All these should be accomplished in one macro in Outlook. So one click, all reports are in PDFs and emails archived. Ideally no files open at the end, and certainly no non-PDF files.
Any questions please let me know. Thanks a lot.
33 freelancers estão ofertando em média $467 para este trabalho
Hi Jason, thanks for the detailed description. We can do all the stuff that you have mentioned in Outlook VBA using only 1 macro. Please reply, we can discuss further, thank you !
VBA expert here. See my portfolio and reviews, contact me to discuss details. You can award me with trust. Thanks, Tom_______________________________
Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office. First day for programming and testing, second for finalization and sign off.