Delete lines in Outlook

Status
Not open for further replies.

CarFle

New Member
Outlook version
Outlook 2013 64 bit
Email Account
POP3
I am sure this is more than simple but my VBA is very weak and my brain has gone on strike!

Every month I receive a number of emails to forward on to clients.
I select Forward and add the recipient.

I would then like help with a Macro to do the following:

Remove the last word in the Subject line
Delete the first 9 lines of the forwarded email
Delete the last 13 lines
Send

I have tried recording in Word and then fiddling in Outlook but at this stage I am no longer concentrating. Is anyone able to help?

Many thanks
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
For the subject, use the InstrRev function, and search for the first space (" ") beginning from the end of the subject. The function returns the position, which can be used with the Left function to retrieve the text left of that position.

If it's Outlook 2007 or newer, you can use Word's library to edit the body. Here's an example for how to get the Word.Document object from an email: www.vboffice.net/en/developers/use-word-macro-in-outlook

When you have a ref on the Document, Paragraphs(1) refers to the first paragraph, which can be deleted with Paragraphs(1).Range.Delete
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If there is always something unique in the line you are keeping that you can search for, like Tracking Number: kjgnoeriounvojdnh you could use regex to find it. But if the paragraphs or lines you want to remove are always the first and last, you can remove them instead.
 

dani7ellee77

New Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
For the subject, utilize the InstrRev capacity, and quest for the main space (" ") starting from the finish of the subject. The capacity restores the position, which can be utilized with the Left capacity to recover the content left of that position.

In the event that it's Outlook 2007 or more up to date, you can utilize Word's library to alter the body. Here's a model for how to get the Word.Document object from an email:

When you have a ref on the Document, Paragraphs(1) alludes to the primary section, which can be erased with Paragraphs(1).Range.Delete
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
J To delete the draft email Using Outlook 0
W Recurrence: delete older occurrences / change earliest start time Outlook VBA and Custom Forms 0
J Moved many emails to Outlook external folder, need to delete on Gmail server Using Outlook 13
A Attachments.Delete Outlook VBA and Custom Forms 3
R Help Revising VBA macro to delete email over different time span Outlook VBA and Custom Forms 0
R Expand VBA Permanent Delete Code Outlook VBA and Custom Forms 6
M Delete headers in Inline reply Outlook VBA and Custom Forms 5
N VBA to delete duplicates by message-id on common pst for 2 or more emails Outlook VBA and Custom Forms 0
S How can I delete all copies of a given companies logo graphic from all my emails at once? Using Outlook 3
9 Outlook 2016 How to save an Outlook attachment to a specific folder then delete the email it came from? Using Outlook 1
D after delete mail, open the next one Outlook VBA and Custom Forms 0
O Delete duplicate emails - subscription notifications Using Outlook 5
F Delete/create/reset Exchange mailbox on Outlook.com Using Outlook.com accounts in Outlook 3
L Email Read and Delete Outlook VBA and Custom Forms 4
H Delete Calendar Entries in Using Outlook 2
D Delete Emails from Senders in Shared Mailbox Outlook VBA and Custom Forms 1
R How to delete Facebook Contacts folder in Outlook 365 Using Outlook 7
R VBA Code to permanently delete selected email Outlook VBA and Custom Forms 10
JoeG Appointment Delete/Change Recurrence Outlook VBA and Custom Forms 0
C Outlook 2016 cannot delete, email showing in root Exchange Server Administration 5
C How to replace or delete first instance of sentence in mail body? Outlook VBA and Custom Forms 1
Z Can't delete IMAP folder Using Outlook 2
J Delete old emails Exchange Server Administration 1
undercover_smother Automatically Forward All Sent Mail and Delete After Send Outlook VBA and Custom Forms 10
T Delete Emails from search results Outlook VBA and Custom Forms 1
I Outlook 2013 How do I delete a Calendar? Using Outlook.com accounts in Outlook 1
N How to delete default folder "Contacts" (olFolderContacts) in a .pst file Using Outlook 8
O How to delete posts New Slipstick.com Articles 1
B How to 'really' delete IMAP emails? Using Outlook 6
H Search and delete part of a link inside HTML body message Outlook VBA and Custom Forms 2
B Delete/replace old files and save new attachments Using Outlook 1
D Delete selected text from incoming emails Outlook VBA and Custom Forms 25
mikolajek Random message selected after hard delete Using Outlook 4
Jeanne Goodman Delete Calendar Item Bypassing Deleted Items folder Outlook VBA and Custom Forms 2
C Delete Subject-Add Organizer to all Reservations in Default Calendar. Using Outlook 0
P Delete mail macro Outlook VBA and Custom Forms 6
B Outlook 2016: Can't delete default calendar but I don't use it Using Outlook 7
O How to delete duplicate RSS messages? Using Outlook 6
J "This item has been changed still want to delete it" message Using Outlook 3
M Can't Delete iCloud Calendar Notifications From Outlook 2016 Using Outlook 0
P Delete Icon Using Outlook 2
makinmyway Bulk Delete Contacts in iOS Outlook App Using Outlook 4
Diane Poremsky Delete an Outlook Group New Slipstick.com Articles 0
M Cannot Delete Emails from IMAP inbox Using Outlook 4
K Deleted calendar and contact items not going to delete folder Using Outlook 1
K Outlook 2013 Deleted calendar and contact items not going to delete folder Exchange Server Administration 1
J Adding Reply & Delete to main toolbar? Using Outlook 0
Reji Rajan Delete Data Outlook VBA and Custom Forms 1
K check for sender, follow to my personal adress and delete the sent folder. Outlook VBA and Custom Forms 1
L Outlook 2007 Delete Email Addresses Using Outlook 19
Similar threads


















































Top