calendar based on report?

**silent1643** · 07-14-2009, 09:11 AM

I have a report which has a few columns

Account Name - Sales Number -Ship Date - Due Date

Is there anyway to take this information and put it into a calendar by ship date or due date??

**zbor** · 07-14-2009, 09:15 AM

Yes, but some workbook example (with some imaginary data that represent real workbook) would be helpfull

**silent1643** · 07-14-2009, 09:19 AM

is this what you need? sample of what the report would look like

Account Num Ship Date Due Date

STORE 1 1130 03/19/2009 04/18/2009

STORE 2 1193 04/25/2009 05/06/2009
STORE 2 1195 04/25/2009 05/06/2009
STORE 2 1196 04/25/2009 05/06/2009
STORE 2 1204 04/25/2009 05/06/2009
STORE 2 1197 05/10/2009 05/20/2009
STORE 2 1199 05/10/2009 05/25/2009
STORE 2 1200 05/10/2009 05/20/2009
STORE 2 1205 05/10/2009 05/20/2009
STORE 2 1171 05/25/2009 06/03/2009

STORE 3 1116 03/17/2009 03/30/2009

**silent1643** · 07-14-2009, 11:09 AM

nevermind i figured out outlook can import what i need -
however is there a way to automatically get rid of extra blank rows?

**SandraY** · 07-15-2009, 09:14 AM

Outlook calendar formatting/editing is very limited.
Now that you have it in Outlook, you may want to consider getting exporting it back to Excel or Word for full editing to meet your needs. You can do this with a 3rd party app called wincalendar. For more info see:
http://www.wincalendar.com/Outlook-Calendar-Import.htm

Sandra