MS Project QuickTip - To move a task in a list, click on the ID number of the task to move. Take the mouse pointer back to the ID number (mouse displays an arrow with 4-pointed star) hold down the left mouse button and move the task to the new position in the task name list. Release the mouse and the task will move.
| Avoiding truncating of data when merging from Excel to Word |
|
|
|
|
To override the truncating of characters when merging cells from Excel to Word that contain more than 255 characters. 1. Restore your mail-merge document to a normal document (Note: All filters/sort criteria will be lost so ensure you make a note of this first). Save and close the document. 2. Open the Tools menu and choose Options 3. Click the General tab and tick "Confirm conversion at open", click OK to accept 4. Re-open the Word document and re-create the Mail Merge - an extra step should appear that allows you to connect to the Excel Data via .DDE - choose this method 5. Re-set your filters/sort options 6. Perform merge and fields should no longer be truncated
|
| < Prev | Next > |
|---|
Northern Courses
| Tue 05 Oct @ 09:30 Speedwriting Skills |
| Wed 06 Oct @ 09:30 Minute Taking |
| Thu 07 Oct @ 09:30 Excel Intermediate |
Southern Courses
| Thu 23 Sep @ 09:30 Speedwriting Skills London |
| Thu 23 Sep @ 09:30 Finance for non-Financial Managers - London |
| Fri 24 Sep @ 09:30 Speedwriting Skills London |
| Fri 24 Sep @ 09:30 Effective Project Management - London |
| Mon 27 Sep @ 09:30 Time and Priority Management |
Events Link
For a full events listing, click here
