• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

create a mailing list from and excel workbook

All

Is it possilbe to create a mailing list based on emails within and excel workbook.

We have a workbook with several worksheets containing email address and other information.

Can we create a mailing list using this workbook.....

Using "MS Outlook"

rgds
0
shaz0503
Asked:
shaz0503
  • 3
1 Solution
 
Brian GeeCommented:
You can accomplish this using Word's Mail Merge function with the Excel file as a data source.

http://support.microsoft.com/kb/294694
0
 
Brian GeeCommented:
If you wish to keep this in Outlook, you can import your Excel file into Outlook so that all entries will be added as new contacts to the Outlook Contacts folder. Just be sure when you come to the Map Custom Fields part of the import to ensure that the fields you have named in Excel are properly matched up with the fields named in Outlook (e.g. the Name fields are set, Email Address fields, etc.).  
0
 
Brian GeeCommented:
From Outlook 2010:

File > Open > Import > Import from another program or file > Next > Microsoft Excel 97-2003 > Next > Browse button to choose your file > Next > select the Contacts folder > Next > Map Custom Fields and then Finish.

Note: Importing from Excel 2010 format (xlsx) is not supported for the import.

From Outlook 2003/2007:


File > Import and Export > Import from another program or file > Next > Microsoft Excel 97-2003 > Next > Browse button to choose your file > Next > select the Contacts folder > Next > Map Custom Fields and then Finish.
0
 
shaz0503Author Commented:
Thanks - will pass this on to the person who requires it ...

rgds
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now