Copy the

Status
Not open for further replies.
J

joe mccarron

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hello

I would really like to be able to copy and paste (into my task list 'Workflowy') the Outlook Today calendar view (pictured below).

It is possible to highlight it but(apparently) impossible to copy either by right click on the mouse or Ctrl+C.

Alternatively, it would be great to recreate the same view. I have tried to do that in the manage views section but can't find the fields that would give me start time and end time and meeting title (and show only the recurring appointments that are happening 'today')

I have found a workaround to get the exact result I want, which is to take a screen clipping of the below, paste it into Onenote, then rely on the OCR functionality to copy the text from the image. That is quite fun, but seems a bit ridiculous.

Thanks for reading and hope you can help.

Joe

upload_2014-10-1_10-11-41.png
 

Attachments

  • upload_2014-10-1_10-8-33.png
    upload_2014-10-1_10-8-33.png
    8.2 KB · Views: 382
You can use a list view and get the fields you need - it doesn't work well with recurring events though. If you paste into Excel and copy you might get an easier to read table.

Create a view - i used next 7 days , no recurrences. I changed the format of the time cells in outlook - if using excel, you could format them in excel. Select all, Ctrl+C then paste into Notepad or Excel, copy and paste into the task. If you don't paste into Notepad or excel first, it pastes the items - use the paste button to change to text . It is slower though.

Format will look like this:

Code: 
Start    End    Subject    Location   
Wed 10/1/2014 12:30 PM    1:00 PM    My Appointment!       
Wed 10/1/2014 10:00 PM    10:30 PM    Your Appointment       
Wed 10/1/2014 11:30 PM    12:00 AM    Online Appointment       
Fri 10/3/2014 2:30 AM    3:00 AM    Contract Ends       
Sat 10/4/2014 9:00 AM    10:00 AM    Hair Cut       
Tue 10/7/2014 1:30 PM    2:00 PM    One More Appointment       
Tue 10/7/2014 3:30 PM    4:30 PM    Troubleshooting the installation    This is a virtual meeting
 
Thanks Diane

Yes. creating the list view goes some way to solving the problem except it can't deal well with recurring items ( think because there isn't a start date field) and there is no fields that present day and date separately (which can be fixed in Excel LEFT, MID etc)

Just such a shame that 'Outlook today' already presents the information exactly as I need it, and that info can be selected, but seems to be read only- would be nice to copy and paste into my list

Thanks for the response.

Joe


Diane Poremsky said:
You can use a list view and get the fields you need - it doesn't work well with recurring events though. If you paste into Excel and copy you might get an easier to read table.

Create a view - i used next 7 days , no recurrences. I changed the format of the time cells in outlook - if using excel, you could format them in excel. Select all, Ctrl+C then paste into Notepad or Excel, copy and paste into the task. If you don't paste into Notepad or excel first, it pastes the items - use the paste button to change to text . It is slower though.

Format will look like this:

Code: 
Start    End    Subject    Location  
Wed 10/1/2014 12:30 PM    1:00 PM    My Appointment!      
Wed 10/1/2014 10:00 PM    10:30 PM    Your Appointment      
Wed 10/1/2014 11:30 PM    12:00 AM    Online Appointment      
Fri 10/3/2014 2:30 AM    3:00 AM    Contract Ends      
Sat 10/4/2014 9:00 AM    10:00 AM    Hair Cut      
Tue 10/7/2014 1:30 PM    2:00 PM    One More Appointment      
Tue 10/7/2014 3:30 PM    4:30 PM    Troubleshooting the installation    This is a virtual meeting
Click to expand...
 
Recurring events use the initial start date - the dates of each occurrence is not used in table view. I have a macro that grabs the dates - if you need to do this often, a macro could grab the upcoming appointments and send them to Excel or just use export and choose the dates - that should correctly export the occurrences.

This shows how to get the occurrences - http://www.slipstick.com/developer/print-list-recurring-dates-vba/
 
Status
Not open for further replies.
< Outlook opens in a small window | Outlook 2013 - profiles >
Similar threads
Thread starter Title Forum Replies Date
C Copy from one Profile to another Using Outlook 0
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
D Copy Appointment Body to Task Body Outlook VBA and Custom Forms 0
M copy field value to custom field Outlook VBA and Custom Forms 0
O In Agenda-view - How to copy an existing item months ahead or back? Using Outlook 0
C Move or copy from field to field Outlook VBA and Custom Forms 0
Z Copy specific email body text Outlook VBA and Custom Forms 0
B Need to Copy an email to a subfolder Outlook VBA and Custom Forms 2
O Outlook 365 - How to create / copy a new contact from an existing one? Using Outlook 5
S Copy Tasks/Reminders from Shared Mailbox to Personal Tasks/Reminders Outlook VBA and Custom Forms 0
A Cannot copy this folder because it may contain private items Using Outlook 0
C Copy Move item won't work Outlook VBA and Custom Forms 2
Z VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
Commodore Move turns into "copy" Using Outlook 3
C Copy Outlook contact field value to another field Outlook VBA and Custom Forms 1
J Copy to calendar function no longer working in outlook 365 Using Outlook 5
F Copy and replace not update contact in another pst Using Outlook 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
Commodore Folders always closed in move/copy items dialog box Using Outlook 3
N Outlook rules don't create a copy for bcc'ed emails Using Outlook 3
geofferyh Outlook 2010 How to Copy Outlook Attachment to a Specific Folder? Outlook VBA and Custom Forms 3
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
R Copy Outlook Public Folders to a File Server Shared Folder Using Outlook 0
K Outlook Rules: Move a Copy Using Outlook 4
oliv- HOW TO COPY /USE FOLDERS ICONS Outlook VBA and Custom Forms 2
E Copy e-mail body from outlook and insert into excel Outlook VBA and Custom Forms 3
B Copy/Move Exchange inbox to Pop inbox Using Outlook 4
R Sending email copy (*.msg file) of sent email if subject line contains specific string. Outlook VBA and Custom Forms 1
O Copy mails from many subfolders to 1 foldr Using Outlook 2
K ind specific Subject line from outlook and copy the content of the email body to exce Outlook VBA and Custom Forms 0
K How to find specific header and copy the mail body Using Outlook 0
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
G Copy Contact field to Appointment Custom Form Field Outlook VBA and Custom Forms 2
G How to Copy Multi Select Listbox Data to Appointment Outlook VBA and Custom Forms 3
Carrie Dickey Outlook 2016 created two calendars titled Calendar1 - appear to be a copy Using Outlook 2
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
R Macro to copy email to excel - Runtime Error 91 Object Variable Not Set Outlook VBA and Custom Forms 11
H Macro to Copy Specific content from Mail Body and Paste to Excel Outlook VBA and Custom Forms 4
M How to keep reccurence during copy tasks to calendar? Using Outlook 1
Diane Poremsky Copy New Appointments to Another Calendar using VBA Using Outlook 0
Diane Poremsky Use a macro to copy data in Outlook email to Excel workbook Using Outlook 0
C Copy Task to Non-Microsoft PIM "Rainlendar" Using Outlook 0
G VBA Copy draft email to a new email - attachments not copided Using Outlook 7
C Copy email to excel runtime error 5020 Using Outlook 5
I Copy email from folder to folder - FAILS Using Outlook 5
M Copy new appointments created in multiple shared calendars to another exchange calendar Outlook VBA and Custom Forms 1
Q Why can't I copy image with embedded hyperlink from email to Word Using Outlook 0
I How to make a copy of a task Using Outlook 8

Similar threads

Back
Top