A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Removing special characters



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 15th 06, 04:50 PM posted to microsoft.public.outlook.program_vba
don
external usenet poster
 
Posts: 120
Default Removing special characters

I am somewhat new to Outlook VBA but can ususally understand enough of some
resonable code to make it work for my situation.

I need to create a macro to remove special characters from all emails
received.
To be specific, we have certain emails that contain a Form Feed character
which causes an extra page to be printed. The sender of this emails send to
various other people that may or may not require the FF character and is
reluctant to remove it.

TIA
DTL
Ads
  #2  
Old February 15th 06, 09:48 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Removing special characters

I'm not sure if this applies in your case, but in Options there's a setting
to remove extra line breaks in plain text messages.

Otherwise, you can use some VBA functions like InStr (to search for an
occurrence of a string within a string), Chr (to get ASCII character from the
ASCII Character Code value) and Asc (to do the reverse of the previous). A
carriage return/linefeed has an ASCII code of 10 or 13.

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Don" wrote:

I am somewhat new to Outlook VBA but can ususally understand enough of some
resonable code to make it work for my situation.

I need to create a macro to remove special characters from all emails
received.
To be specific, we have certain emails that contain a Form Feed character
which causes an extra page to be printed. The sender of this emails send to
various other people that may or may not require the FF character and is
reluctant to remove it.

TIA
DTL

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Old Calendar Appointments Brian Doc Outlook - Calandaring 1 February 10th 06 02:40 PM
Setting up a special reoccuring appointment Sue Outlook - Calandaring 0 February 1st 06 10:59 PM
Outlook 2003 IMAP Special Folders? Marc Ferguson Outlook - General Queries 1 January 31st 06 07:37 PM
Outlook 2003 IMAP Special Folders? Marc Ferguson Outlook - General Queries 0 January 31st 06 04:19 PM
language characters tomber77 Outlook - Installation 0 January 9th 06 02:34 PM


All times are GMT +1. The time now is 06:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.