Delimiters in Subject line

Status
Not open for further replies.
S

S2lyYW4

Hi,

Can I remove all the delimiters (like ,:;-) in the subject line for

the mails in my pst.

Thanks

Kiran
 
Yes.

Best regards

Michael Bauer

Am Mon, 11 May 2009 02:25:01 -0700 schrieb Kiran:


> Hi,
> Can I remove all the delimiters (like ,:;-) in the subject line for
> the mails in my pst.

> Thanks
> Kiran
 
How do I do that?

Thanks

Kiran

"Michael Bauer " wrote:



> Yes.

> > Best regards
> Michael Bauer

> > >

> Am Mon, 11 May 2009 02:25:01 -0700 schrieb Kiran:
>
> > Hi,
> > Can I remove all the delimiters (like ,:;-) in the subject line for
> > the mails in my pst.
> > Thanks
> > Kiran
>
 
This does it for one selected mailitem:

Dim Mail As MailItem

Set Mail=Application.ActiveExplorer.Selection(1)

Mail.Subject=Replace(Mail.Subject, ";", "")

Mail.Save

Here's a sample for how to loop through all of your folders:

http://www.vboffice.net/en/developers/looping-recursively-through-folders-and-subfolders

Best regards

Michael Bauer

Am Tue, 12 May 2009 05:34:04 -0700 schrieb Kiran:


> How do I do that?

> Thanks
> Kiran

> "Michael Bauer " wrote:
>
>

>
>> Yes.
>

>> > > Best regards
> > Michael Bauer
>

>> >> >>

>

>
>> Am Mon, 11 May 2009 02:25:01 -0700 schrieb Kiran:
> >
> >> Hi,
> >> Can I remove all the delimiters (like ,:;-) in the subject line

for
> >> the mails in my pst.
> >
>>> Thanks
> >> Kiran
> >
 
Status
Not open for further replies.
< Olk2003 displaying an error message | message attachment saved by Outlook.Attachment.SaveFileAs not open >
Similar threads
Thread starter Title Forum Replies Date
H using VBA to edit subject line Outlook VBA and Custom Forms 0
F Auto changing email subject line in bulk Using Outlook 2
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
J Outlook 365 Forward Email Subject to my inbox when new email arrive in shared inbox Using Outlook 0
sjmo2 Change subject for new e-mails only. Outlook VBA and Custom Forms 2
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
D Prompt to prefix subject line whenever sending an email Outlook VBA and Custom Forms 3
ill13 Prepend the user's computer name to the subject. Outlook VBA and Custom Forms 1
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
2 How to get rid of the "Emailing:" prefix in the subject line Using Outlook 1
S Outlook Macro for [Date][Subject] Using Outlook 1
O How to find and replace a word in Outlook-Agenda-Subject and Message? Using Outlook 0
D ISOmacro to extract active mail senders name and email, CC, Subject line, and filename of attachments and import them into premade excel spread sheet Outlook VBA and Custom Forms 2
C Outlook 365 Subject Prefixes? Outlook VBA and Custom Forms 1
A Macro to file emails into subfolder based on subject line Outlook VBA and Custom Forms 1
N Save selected messages VBA does not save replies and/or messages that contain : in subject Outlook VBA and Custom Forms 1
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
R Disable conversation thread from replying of recipients in the same subject. Please help Using Outlook 0
M Outlook 2013 Script Assistance - Save Opened Link with Subject Added Outlook VBA and Custom Forms 1
C How to rename subject line and forward the email Outlook VBA and Custom Forms 2
B Add Prefix text to Subject Line Using Outlook 1
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 16
M Outlook 2013 Replace Subject with Conversation (a "hidden" value). Outlook VBA and Custom Forms 0
M Convert Subject Line to Internet Header version of Subject Outlook VBA and Custom Forms 10
M Adding Subject to this Link-Saving VBA Outlook VBA and Custom Forms 5
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
B Remove Subject Residual Outlook VBA and Custom Forms 3
F VBA to ensure a code is entered in Subject title Outlook VBA and Custom Forms 1
A Check for words in subject header before sending email Outlook VBA and Custom Forms 4
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
Z Outlook Custom Form: Adding Dropdown(Project Code) at the end of subject Outlook VBA and Custom Forms 0
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
M Making Subject field writable (disable Read Only) Outlook VBA and Custom Forms 2
M Adding Macro to populate "to" "subject" "body" not deleting email string below. Outlook VBA and Custom Forms 5
G Download pdf attachments only if email subject has one of words Outlook VBA and Custom Forms 8
C Change Subject Line in Selected Emails Outlook VBA and Custom Forms 1
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
D Edit Subject (Multiple Accounts) Outlook VBA and Custom Forms 5
E Outlook 2010 Subject sort uses Thread-Topic for grouping Using Outlook 2
C Outlook - cannot save subject line changes Using Outlook 2
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
E Search for folder by key in subject then move new message to related folder Outlook VBA and Custom Forms 1
R Chancing / remove “ something ” in the subject, online archive Outlook VBA and Custom Forms 8
I print calendar without subject and details Using Outlook 1
O On click,I want to change subject line of selected mail and then reply to particular email and move Using Outlook 3

Similar threads

Back
Top