PDA

View Full Version : Error Related to format in a PARAGRAPH



BACI
01-22-2014, 02:50 PM
Hi All,

Thank you for all your previous suggestion. As I am still leaning VBA request for an assistance and guidance.

I have work related to writing emails to the customer. I have a team of 5 people.

When we write an email most of the error we commit on the following.

1. Date and Amount : people commit error on update the date in mm/dd/yyyy format that is January 23, 2014, else some time they forget to enter "," or SPACE or specfic SPACE required.

2. Spelling Errors
3. Detect special characters.
4. Punctuation errors.
5. SPACE between words

Please suggest

Regards,
BACI:think:

BACI
01-22-2014, 11:09 PM
Trying to create a marco in excel or word where I can copy my letter and the requirements get edited or sepeartly gets highlighted or anythinglike this !Please suggestRegards

westconn1
01-23-2014, 04:09 AM
in word you can use the built in spelling and grammer checking
which is probably why, in many cases, word is the default email editor

BACI
01-23-2014, 01:39 PM
Hi,

Thank you for the suggestions.

is there any possibility in word or in excel for

1. Date and Amount : people commit error on update the date in mm/dd/yyyy format that is January 23, 2014, else some time they forget to enter "," or SPACE or specific SPACE required.


3. Detect special characters.
4. Punctuation errors.
5. SPACE between words

Please assist

Regards

westconn1
01-24-2014, 01:31 AM
people commit error on update the date in mm/dd/yyyy formatuse a calendar or other datepicker control


4. Punctuation errors.
5. SPACE between wordsgrammer checking


3. Detect special characters.put a button to apply the tags to selected text

BACI
01-24-2014, 02:24 PM
Hi,

Thank you for your help and suggestion :)

I wanted to create a macro so that when I place my letter content it highlight the above mentioned and on other side it correct the same.

please help.

Regards,