A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How can I easily export mailing addresses?



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old August 5th 08, 01:40 AM posted to microsoft.public.outlook.contacts
Stuart Dole
external usenet poster
 
Posts: 4
Default How can I easily export mailing addresses?

Hi:

I'd like to be able to export the "mailing address" of a selected group of
contacts - either by category or group. Note that the "mailing address" is
either the business address or the home address, depending on the check-mark
in the individual contact.

I'd like it to end up in Excel (imagine that!) with columns for "Full Name"
and "Mailing Address" - like I can display it in the "view by category" list.

I tried to simply copy and paste (seems like it *should* work) into Excel,
but alas it makes TWO (2) rows for each contact, somehow split in the middle
of the "Mailing Address" field. (Why is it being so difficult?)

How about a simple "Export as CSV" or some such?

The eventual target of all this is an on-line postcard printing company that
wants an Excel workbook of the addresses in a simple format (First Name, Last
Name, Address, City, State, ZIP).

I need to be able to do this by Groups too!

Any suggestions welcome.

(This used to be easy with ACT!, but now ACT! is broken...)

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Contacts with mailing addresses are missing Danna Barron Outlook - Using Contacts 1 January 25th 07 04:03 PM
How can I find the get ZIP+4 code for Outlook mailing addresses WDR Outlook - Using Contacts 0 December 15th 06 07:06 AM
How to add mailing addresses to a distribution list broncos Outlook - Using Contacts 2 December 13th 06 09:11 PM
How can I export the mailing address field? Adam Outlook - Using Contacts 1 August 7th 06 11:20 AM
Delete USA in contacts as mailing addresses Finnsbride Outlook - Using Contacts 12 May 13th 06 10:43 PM


All times are GMT +1. The time now is 08:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.