change the custom fields when export emails to excel

Status
Not open for further replies.
C

c21pbGVyX3Jvc3N5

Want to use specifed forms and then export these specfied fields into an

excel file
 
S

Sue Mosher

Outlook doesn't support exporting custom fields directly. Quick and dirty

method:

1. Put all the items from your form in one folder.

2. Use a table view to display all the data fields that you want to export

to Excel.

3. Choose Edit | Select All.

4. Choose Edit | Copy.

5. Paste to Excel.

If some of the fields are multi-line, see Eric Legault's handy tip for an

Excel formula to break up the lines

http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx

The alternatives are to write your own custom VBA code or to use a

third-party application. See http://www.outlookcode.com/article.aspx?ID=23

Sue Mosher

"smiler_rossy" wrote:


> Want to use specifed forms and then export these specfied fields into an
> excel file
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
D Change sender name outlook vba 2010 Custom Userform Outlook VBA and Custom Forms 1
witzker Change icon for custom views Using Outlook 1
J How Can I Change Owner of Custom Contact? Using Outlook 1
G How to make a change to a custom view and have the changes automatically update in all folders using that view Using Outlook 1
S how to add my custom items to "Change E-mail Account" dialog Outlook VBA and Custom Forms 1
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 3
B Change row background color of selected item Using Outlook 1
PGSystemTester VBA To Change AppointmentItem.BusyStatus From MeetingItem Before Send Using Outlook 0
B Change from Address Outlook VBA and Custom Forms 0
X If you change expiration date of repeated task it dupplicates Using Outlook 1
E How to display "Change Folder" in Change Default Email Delivery Location in Exchange Outlook 2016 Using Outlook 1
B See "Change View" Drop Down as a List? Using Outlook 1
V Change start time based on message duration Outlook VBA and Custom Forms 2
R Folder pane width change Using Outlook 45
S Change VBA script to send HTML email instead of text Outlook VBA and Custom Forms 3
S Outlook 2010 unable to change default font Using Outlook 7
P How can I change my calendar view back Using Outlook 3
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
T Change the selected Message in the Outlook window Outlook VBA and Custom Forms 2
geofferyh How to change the Attachment File Name? Outlook VBA and Custom Forms 1
W Appointment occurrences change the location property Using Outlook 0
T Scheduled footer change Using Outlook 2
B Change font of reminder of an email header Outlook VBA and Custom Forms 3
CWM030 Name Change? Exchange Server Administration 9
V not able to change name in customize Ribbon Outlook VBA and Custom Forms 1
JoeG Appointment Delete/Change Recurrence Outlook VBA and Custom Forms 0
C Change Subject Line in Selected Emails Outlook VBA and Custom Forms 1
V Change default default save location to Quick Access Using Outlook 1
C Change default "Save Sent Item To" folder Outlook VBA and Custom Forms 9
S Example VBA Macro - To Conditionally Change the From Account and Add a BCC Address on Emails Outlook VBA and Custom Forms 11
B Do not change the From address in Outlook Templates Using Outlook 0
M Sudden change in From field - now very short Using Outlook 4
M cannot change delivery folders with IMAP accounts Using Outlook 0
S Email Format With Embedded Images and Tables Change Using Outlook 2
O On click,I want to change subject line of selected mail and then reply to particular email and move Using Outlook 3
P Change PC User Directory & iPhone Sync Using Outlook 2
A Change order of actions in one (!) rule Outlook VBA and Custom Forms 2
I change subject and forward without FW: Outlook VBA and Custom Forms 4
Rupert Dragwater Can't change font size Using Outlook 5
M VBA to change flag status in outlook contact item Outlook VBA and Custom Forms 3
J Auto Forward - Include Attachment and change Subject depending on original sender Outlook VBA and Custom Forms 3
tjd189 outlook 2016 name change Using Outlook 1
E Button to change subject Outlook VBA and Custom Forms 1
K Paste from Windows Clipboard then change font without losing formatting Outlook VBA and Custom Forms 1
D Office365 Conference Room name change? Using Outlook 5
J Change POP account to Forwarder - What happens in Outlook? Using Outlook 2
H Change Default Email Account Using VBA Outlook VBA and Custom Forms 5
C Change default colors for conditional formatting Using Outlook 2
O VBA to Run Font Change on Outlook Startup Outlook VBA and Custom Forms 4
K Other Shared Calendar on Outlook cannot change items Using Outlook.com accounts in Outlook 7
Similar threads


















































Top