View Single Post
 
Old 09-16-2021, 07:35 AM
James Martin James Martin is offline Windows 10 Office 2019
Novice
 
Join Date: Sep 2021
Posts: 7
James Martin is on a distinguished road
Default

Thanks, will set up in next few days and check I get it to work, and remember to put this web page as a note in the macro for credit and reference.

For Context I have created a Macro t to save customer Outlook Item as text, and Macro A to save all attachments ready for upload - this saves to a folder up a level from Macro t, and kills /deletes the previous running of Macro A.

I have created a Macro T to save a customer Outlook item as docx, the advantage being that embedded photos of docs from customer mobiles are captured and these are not attachments. Still trying to resolve the paste K as images are oversized and my macro just imputs all objects/items. I will post all these macros when done.

Once this Macro R for rotate is resolved, I will be able to do macro C to compress images in docx Macro T further beyond natural good compression, to 150ppi or 95ppi, as we have a 4MB upload limit to a customer system.

I intend to do a Macro I to paste all image attachments at the end of Macro T active document. And similarly Macro W for doc, docx or rtf attachments, but some thought is needed if practical as need to code page break, and break the Header and Footer links - might be better to copy opened doc/rtf and copy and paste, as increasingly editors lock editable settings, or have password and won't work.

Should be able to combine Macros T, I, W and c(150ppi as 95ppi can make text unreadable).

We use CutePdf Writer which is a bit fiddly, but there is some code on their website so a Cute macro may be possible for maximum file compression via print in Adobe Reader, colleagues don't know how to reverse the page running order or rotate pages before printing to correct.Very large pdfs are a pain to split into smaller sections under 4MB, maybe a CuteS macro can be created.

Our IT Dept might be able to use RPA to OCR pdfs and correct orientation of pdfs and other images in Macro T - we don't have Adobe Professional to manually do compression,split or general formatting.

I am manually print screening landscape full screen from Adobe and pasting into my docx manually created from forwarding the email and selecting the body to paste which wraps/justifies all embedded images but does not include the attachment list. We have a real problem with so many unspecified files being uploaded and there are massive delays in processing and rereading the data, so I instinctively put everything I can in one docx manually, with a good file description.

For macro t, T and A, I have used this site which is very helpful://www.slipstick.com/outlook-developers/developer-index/
Reply With Quote