Office-it.orG

How to Prevent Spam Bots From Collecting Email Addresses

As I mentioned before in How to Include Subject, CC, BCC, and Email Body in Email Links, you are creating a risk to get spam if you simply placing email addresses on a page without encoding them.

Some websites using “[at]” to replace “@” and email will look as “name [at] domain.com”. This is a good idea for personal websites since nobody challenge you. In commercial, many clients wouldn’t allow you to use “name [at] domain.com” this format. They are not web designer and they don’t understand how spam prevention works, or even care for that matter.

I have this method originally from david walsh blog. Its author have a quick PHP script that you can use when putting raw email addresses on a page:

(more…)

Popularity: 54%

Posted in Javascript, PHP, Web Tools | 1 Comment »

How to Include Subject, CC, BCC, and Email Body in Email Links

It is so easy to create a email link in our web page. Everyone who know or even don’t know HTML, they can easily create an email link by software.

<a href="mailto:email@office-it.org">Email Office-it.orG</a>

However, they are not always know that they can include subject, CC, BCC, and email body text information in the link as well. By using a querystring-like syntax, we can do more with that simple link.

Example code to add the subject:

<a href="mailto:email@office-it.org?Subject=Your Subject Here">
Email Office-it.orG
</a>

Example code to add the cc’s and bcc’s:

<a href="mailto:email@office-it.org?Subject=Your Subject Here&CC=email2@office-it.org&BCC=email3@office-it.org">
Email Office-it.orG
</a>

(more…)

Popularity: 55%

Posted in XHTML | 1 Comment »

Excel: How to Unprotect Worksheet Without Password

You may sometimes forgot your password of your Microsoft Excel sheet or workbook, or the original author (usually ex-colleague) lock the workbook and didn’t unlock it for next user, the marco below will unlock your sheet or workbook not matter what your original password is. However, it it will NOT report the original password.

How to unprotect

1. First open your protected excel file
2. Launch the Visual Basic Editor
3. Copy and paste the following VB Code

(more…)

Popularity: 57%

Posted in MS Office | 1 Comment »