Outlook exporting

R

rcolving

Board Regular
Joined
May 23, 2002
Messages
124
Office Version
  1. 365
  2. 2021
  3. 2019
  4. 2016
  5. 2013
Platform
  1. Windows
I have a contacts folder with approx. 2300 contacts in it. I want to export this list to excel but want to only export First Name, Last Name, and Mailing Address. When I go to map the appropriate fields there is no option to export the mailing address only. It only shows either home address, business address, or other address. This doesn't work because sometimes the mailing address is the home address and sometimes its the business address. Does anyone know how I can export the file with the mailing address only? :banghead:
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You must log in or register to reply here.

Similar threads

earthworm
  • Question Question
Apply rule in Outlook 365 where my name is To box and my name is also in multiple email distribution group
Replies
0
Views
189
earthworm
earthworm
R
  • Question Question
Mail merge to insert the picture in the mail body and schedule the email
Replies
0
Views
1K
rafeek4u
R
A
  • Question Question
Outlook File Attachment using VBA
2 3
Replies
22
Views
3K
RoryA
RoryA
J
  • Question Question
Create protected PDFs (with an Open password and/or a Permissions password) with Adobe PDF Services API
Replies
0
Views
91
John_w
J
W
  • Question Question
Excel online - confirming info
Replies
0
Views
766
wallum
W

Forum statistics

Threads
1,224,856
Messages
6,181,427
Members
453,040
Latest member
Santero

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top