Wednesday, August 7, 2013

How To Create Personalized Multi-Recipient Mass Emails Quickly Using Outlook Mail Merge

How To Create Personalized Multi-Recipient Mass Emails Quickly Using Outlook Mail Merge
1. In Outlook, go to your Contacts and Select which contacts you would like to send yourmass personalized email to.
2. Next above on the toolbar Click Mail Merge.
3. The mail merge options should pop-up in a new window.  At the top, Check Only selected contacts. At the bottom, Set the Document Type to Form Letters, and Merge Toto E-mail.
The Message subject line can be set to whatever subject you want the email to have. In this example I want the subject title of all the emails to be Check out our latest article.
Click OK to continue.
When you Click OK a new compose email will open up.  From here all of the contacts are stored so no need to worry about adding them unless you forgot someone.
4. In the compose email window, let’s add a personalized Greeting.  Click Greeting Line.
5. In the pop-up window you can customize your Greeting line, but default works fine. Click OK to continue.  The preview will show what greeting will be displayed for each person receiving the email, but while you are composing it will look like «Greeting Line».
6.   Optional:  If you have any more custom fields you want to enter Use the Insert Merge Field button to do so, there are a lot of things to choose from, but this will require you have the related information in your contacts profile in Outlook.  If you don’t, no worries, just keep on reading!
7. Write your email content!  This is the part that will be the same for all recipients.
8. When you are all done writing Click Finish & Merge, then Select Send E-mail Messages…
9. A pop-up will appear to confirm you want to send and the information is correct.  ClickOK and off the mail goes!
Now you’ve sent out your mass email to all of your contacts!  When they receive it it will only show their email under the “to” field.  The greeting line and whatever else you decided to personalize will be tailored to their specific information pulled from your Outlook contacts list.


How to Stop Microsoft Outlook From Receiving Duplicate Emails

Ensure Only One Instance is Running
Step 1
Right-click the taskbar and click "Start Task Manager."
Step 2
Click the "Processes" tab.
Step 3
Click the "Image Name" column. This sorts all processes alphabetically. You should only have one "Outlook.exe" listed. If you have more than one listed, you may receive duplicate emails.
Step 4
Right-click one of the "Outlook.exe" listings and click "End Task." Click "Yes" on the confirmation dialog.
Avoid Leaving Copies of Messages on Server
Step 1
Open Outlook.
Step 2
Click "Tools" and click "Email Accounts."
Step 3
Click "View or Change Existing Email Accounts" and click the "Next" button.
Step 4
Select your email account from the list and click "Change."
Step 5
Click the "More Settings" button and then click the "Advanced" tab.
Step 6
Click to remove the check in the box next to "Leave a copy of messages on the server" and click the "OK" button.
Profiles with Two POP3 Accounts
Step 1
Open Outlook.
Step 2
Open the "Tools" menu.
Step 3
Click "Send/Receive Settings" and click "Define Send/Receive Groups."
Step 4
Double-click the group to display the accounts.
Step 5

Click one of the two accounts and remove the check from the box next to "Receive mail items."

Monday, January 14, 2013

SQL SERVER 2008R2 Data Base Creation Problem Error the system cannot find the file specified. (sqlmgmt)



Hello friends,

are u getting this problem 

Data Base Creation Problem Error 

the system cannot find the file specified. (sqlmgmt)

have you upgraded your SQL Server ?  

Solution 

Copy the file Microsoft.SqlServer.Sqm.dll located on 

C:\Program Files\Microsoft SQL Server\100\Shared to folder C:\Program Files\Microsoft SQL 

32 Bit : Server\100\Tools\Binn\VSShell\Common7\IDE and


 64 Bit : C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE.