Solved

Outlook Mass Mailing

Posted on 2011-09-06
2
315 Views
Last Modified: 2012-05-12
I'd like to e-mail 1000+ people with their login and password information. I don't want to use an attachment. I want to insert their login and password into the body of the e-mail text. These e-mail accounts will not be used for a mailing list. The login, password, and e-mail address are in an EXCEL file.

How do I do this?
0
Comment
Question by:dwiseman3
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
jayca earned 500 total points
ID: 36489946
http://www.howto-outlook.com/howto/mailmerge.htm

Mail Merge from Word with another source
 
When you want to send out personal emails via Outlook but the information itself isn’t in Outlook, then you can start your mail merge from within Word as well. The process is similar as doing a mail merge from within Word with Outlook as the source with additional step of matching the merge fields.
 1.Start the mail merge from Word again as indicated above until you reach the screen with Step 3 in the Mail Merge Wizard.
2.In Step 3 select "Use an existing list".
3.Click the Browse… button.
4.Select the location of the document containing the information. This can be Excel sheets, Access Databases, Database Queries, Text Documents and many other sources as long as it is in a structured format Word can work with.
Depending on the file type you selected you might need to put in the delimiters; the characters that are used to separate the columns and rules.
5.After you have selected the file and optionally filtered your contacts to address, continue to Step 4.
6.When you reach Step 4, it is a good time to match the fields from your source to Mail Merge fields to be able to use the predefined blocks such as "Greeting Line".
For instance, when you have an Excel sheet that contains the columns Name, Email Address, Usernames and Passwords, you’d want to match the Name field to the "Last Name" merge field. a.Match the fields;
Word 2007 and Word 2010: press the Match Fields button.
Word 2003: press the 10th icon from the left (labeled Match Fields) on the Mail Merge toolbar shown above.
b.You’ll now get a dialog with standard Merge Fields in Word which can be used in standardized templates.
c.Expand the drop down list next to "Last Name" and set it to the column in your source document (in our case an Excel sheet) containing that information (in our case the column "Name").
d.Match up other fields if you need and press OK to close the dialog.

7.You can now continue with the mail merge as indicated in the process above.
8.When you get to the dialog to send the messages, you must set the "To:" field to the column that contains the list of email addresses to send to.
0
 

Author Closing Comment

by:dwiseman3
ID: 36492514
Thank you for the detailed explanation.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question