Send email from Microsoft excel with customized sheet data

Hi folks,

Have you ever faced requirement where you have to send email from an excel with excel data. If you are in that situation, this blog makes your life easier.

Pre-requisites

Send customized excel data of each row as an email. You should have data in each row and you should know have recipient e-mail address

You should have configured e-mail client like outlook, mail of desktop

Procedure

1. Use Hyperlink function of excel
• Syntax
• =HYPERLINK("mailto:"&e-mailCellNo&"?subject="&subjectCellNo&"&body="&bodyCellNo&"%0A","Send email")
• Help
• Cellno in syntax should point to your data cell number
• %0A - New line
• mailto - The recipient mail address
• subject - the text
• body - the body text
• Note
• If you have any special characters, then use ENCODEURL function
• Don't put the ENCODEURL function in HYPERLINK function
• Make sure, ENCODEURL output points to a different cell and use that cell number in HYPERLINK
2. Use $ to use the same cell data repeatedly
3. After doing the hyperlink to a cell, you should be able to view "Send email"
4. Click on the send email
5. Opens the configured/default e-mail client by filling the recipient, subject and body content from excel sheet
6. Click on "send" or "Ctrl+Enter" keyboard shortcut to send email

Hope, this helps you to explore excel and send email with excel data to many recipients with single click

Please send your valuable feedback and comments to psrdotcom@gmail.com

Add custom user/system attributes in Active Directory

Hi folks,

Today I'll explain the procedure to add and verify the custom user attributes in Active Directory.

Mount the Directory Schema

1. Open Command Prompt in Administrator mode
• Start -> cmd -> Right click and select "Run as Administrator"
2. Mount the directory schema command
• cmd> regsvr32 schmmgmt.dll
3. You will be notified with command success pop-up
• Click on Ok

Creating Custom Attribute

• Open mmc (Management Console)
• Click on "File" menu and select "Add/Remove Snap in.."
• From "Available snap-ins" section, click "Active Directory Schema"
• Click on "Add"

• "Active Directory Schema" should be added to "Selected snap-ins" section and click "Ok"
• You will be viewing the "Active Directory Schema" in the console
• Expand and select "Attributes"
• Right click and choose "New" and select "Attribute" as shown below

• A warning pop-up shows, click Continue

• Create New Attribute pop-up opens up
• Enter the custom attribute details
• Enter the Object ID as per Reference 1

• Select the Syntax from the list

• Check Multi-Valued option based on your requirement
• Click Ok

Adding to User Class

• Newly created custom attribute has to be mapped to any one of the class (Computer, user etc)
• To add it to user
• (Classes -> User -> Properties -> "Add")
• Select the custom attribute

Restarting ADDS (Active Directory Domain Service)

• Open Services
• Start -> Run -> services.msc
• Navigate to Active Directory Domain Service
• Restart the service

Verification

• Open "Active Directory Users and Computers"
• Go to "Users"
• Click on any user and view properties
• Click on "Attribute Editor" tab
• Navigate to your custom tab

References

1. https://social.technet.microsoft.com/wiki/contents/articles/20319.how-to-create-a-custom-attribute-in-active-directory.aspx
2. https://www.youtube.com/watch?v=__92mHwyZ3Q

Please send your feedback to psrdotcom@gmail.com

Create custom mozilla firefox profile with browser settings customization in Ubuntu and Windows

Hi all,

Today I have customized my mozilla firefox browser with custom settings by creating my own profile in my user account.

Follow these steps in creating the custom profile for firefox in Ubuntu

1. Open terminal (Keyboard Shortcut Key: Ctrl+Alt+t)
2. Change the directory to mozilla preferences directory for user
• $ cd ~/.mozilla/firefox
3. Create a new directory yourname.default
• ~/.mozilla/firefox$ mkdir psr.default
4. Open the existing profiles.ini file
• ~/.mozilla/firefox$ gedit profiles.ini &
5. Replace the Path variable with the following
• Path=psr.default
6. Save and close the profiles.ini file
7. Change the directory to psr.default
• ~/.mozilla/firefox$ cd psr.default
8. Create a user.js file
   
• ~/.mozilla/firefox/psr.default$ gedit user.js &
9. Edit the all possible settings by following the references, which are listed down
10. For Windows Operating System mozilla firefox browser customization, you can follow this link http://www.pcc-services.com/kixtart/firefox-lockdown.html

References:http://www-archive.mozilla.org/unix/customizing.html#prefs
http://thegoldenear.org/toolbox/windows/docs/mozilla-pre-config.html
http://www.pcc-services.com/kixtart/firefox-lockdown.html
http://www.eng.uwaterloo.ca/twiki/bin/view/Linux/FirefoxLockdown

If you have any queries, please write to psrdotcom@gmail.com

Customize Command Prompt in Windows 7 with your own Icon, Starting Directory and more settings ...

Hi all,

Are you getting bored with the same command prompt with black colored background and other settings?

You can customize your own command prompt and you can start from the preferred location (Directory) path, choose your own icon and lot more.

Go ahead by following the below steps ..


Creating the shortcut icon on Destop

1. Right click on the desktop, select "New" -> "shortcut"
2. Browse for the command prompt executable file "cmd.exe"
3. If you have installed your Operating System in C drive then the path might be similar to this
4. C:\Windows\System32\cmd.exe
5. Click on "Next"
6. Type the name for this shortcut, something like "MyCmdPrompt"
7. Click on "Finish"
8. Now you can see your command prompt named of your own choice
9. Now, you can change some properties of your command prompt

Changing the properties of the custom command prompt

• Right click on the newly created shortcut from the Desktop

• Select "Shortcut" tab and change the following settings

1. Change the starting directory: Specify your own choice of directory path in the "Start in" box.
2. Default Start in path: C:\Windows\System32
3. Change the icon of your own choice: Click on "Change Icon" and Click on "Browse" button and Select the "C:\Windows\System32\imageres.dll" to list all the windows installed icons.
4. Select an icon of your own choice and Click on "Ok"
5. Run as Administrator by default: Click "Advanced" button, Select "Run as administrator" and Click "Ok"

• Select "Options" tab and change the following settings

1. Check "Quick Edit mode" to copy and paste easily

• Select "Font" tab and change the following settings

1. select your desired "Font" and "Size" settings

• Select "Layout" tab and change the following settings

1. select your desired "Window Size"
2. Note: To see a bigger screen, increase the "Width and Height" attributes of the "Window Size"
3. You can preview, your settings in the left side preview

• Select "Colors" tab, You might be bored by seeing the same black and white combination.

1. Choose your desired colors for Background, Foreground colors for both the "Screen" and "Pop-Up screen"

• Click on "Apply" and then "Ok" to see your own command prompt.

Hope this post is useful to you customize your own Command Prompt in Windows 7.

For further queries, mail to psrdotcom@gmail.com

Create a custom theme in Windows 7

Hi everyone,
If you are bored with the themes in your windows 7 .. Just create a custom theme with your own photos and icons etc.

You can create or select your own cursors, sounds, visual styles in customized theme.

Just some patience is enough to do all ..
Lets do it !!

The Theme File Format : http://msdn.microsoft.com/en-us/library/bb773190(VS.85).aspx
Send me your customized theme to me also .. :)