Computer Tech Tips

show advanced search
search criteria = ALL

The last message(s) which were posted to this eGroup

1 to 10 of 1877 messages
Display messages per page
Date Subject Author
view by date
Sep 25, 2014
1. RE: Prezi Deborah Mitchell
Sep 24, 2014
2. RE: Prezi Ann Dahlke
3. RE: Prezi Judithann Lovely
4. RE: Prezi Ann Dahlke
5. Prezi Judithann Lovely
Sep 19, 2014
6. RE: Outlook Contacts form design Christa Vincent
7. RE: Word 2010 - issues with merge codes Kimberley Perry
8. RE: Word 2010 - issues with merge codes Kimberley Perry
9. RE: Word 2010 - issues with merge codes Catherine Scribner
Sep 18, 2014
10. RE: Word 2010 - issues with merge codes Wendy Fan


1.
RE: Prezi
From: Deborah Mitchell
To: Computer Tech Tips
Posted: Sep 25, 2014 8:12 PM
Subject: RE: Prezi
Message:

Try Lynda.com. There is a course online for Prezi under learning.
-------------------------------------------
Deborah Mitchell
Executive Administrative Assistant
Naperville, IL
-------------------------------------------

Show Original Message
1 person recommends this.


2.
RE: Prezi
From: Ann Dahlke
To: Computer Tech Tips
Posted: Sep 24, 2014 9:56 AM
Subject: RE: Prezi
Message:
Darn!  Hopefully, one of our other many helpful members will have a great cost-effective idea for you.

-------------------------------------------
Ann Dahlke, CAP-OM-TA
Senior Administrative Assistant
Wausau, WI
Wausau Chapter / Wisconsin Division
2014-2015 Wisconsin Division President-Elect


-------------------------------------------


Show Original Message
Be the first person to recommend this.


3.
RE: Prezi
From: Judithann Lovely
To: Computer Tech Tips
Posted: Sep 24, 2014 9:04 AM
Subject: RE: Prezi
Message:

No, Ann...no one in our area teaches it at this time nor are they familiar with it. We tried that avenue first.
-------------------------------------------
Judy Lovely, CAP-OM
Knoxville Chapter
Tennessee Division
Past Division President

Paralegal
Gardiner and Associates
Knoxville, TN

Member of Excellence since 2008


----------------------------------------------------


View Judy Lovely, CPS/CAP's profile on LinkedIn


-------------------------------------------


Show Original Message
Be the first person to recommend this.


4.
RE: Prezi
From: Ann Dahlke
To: Computer Tech Tips
Posted: Sep 24, 2014 8:54 AM
Subject: RE: Prezi
Message:
Do you have any local technical schools or colleges in your area?  We found some one to present on Prezi for us who is an instructor at Rasmussen College.

-------------------------------------------
Ann Dahlke, CAP-OM-TA
Senior Administrative Assistant
Wausau, WI
Wausau Chapter / Wisconsin Division
2014-2015 Wisconsin Division President-Elect


-------------------------------------------


Show Original Message
Be the first person to recommend this.


5.
Prezi
From: Judithann Lovely
To: Computer Tech Tips
Posted: Sep 24, 2014 8:49 AM
Subject: Prezi
Message:
We are looking for someone who can present at a tech seminar in November on Prezi. Can't afford to pay much but wondered if there was anyone within driving distance of Knoxville that would be willing to talk with us about the possibility.

Thanks in advance!

-------------------------------------------
Judy Lovely, CAP-OM
Knoxville Chapter
Tennessee Division
Past Division President

Paralegal
Gardiner and Associates
Knoxville, TN

Member of Excellence since 2008


----------------------------------------------------


View Judy Lovely, CPS/CAP's profile on LinkedIn


-------------------------------------------
Be the first person to recommend this.


6.
RE: Outlook Contacts form design
From: Christa Vincent
To: Computer Tech Tips
Posted: Sep 19, 2014 5:36 PM
Subject: RE: Outlook Contacts form design
Message:
There is a much easier way to do this!  When in the contact folder you wish to modify, click View, Current View, Customize Current View or Define View to create a new view.  If you are customizing your current view, click Show Fields, at the bottom of that screen there is a "Select available fields from:" drop down - drop and scroll down to "All Contact Fields".  Those fields will then populate the "Available Fields" list above. Scroll down to "Created" - click the "Add" button, hit OK. Click OK to get out.  The Created date will appear at the bottom of all contacts in that folder.  

You can apply different views as needed.

-------------------------------------------
Christa Vincent, CAP
Executive Administrator
Houston, TX

-------------------------------------------


Show Original Message
1 person recommends this.


7.
RE: Word 2010 - issues with merge codes
From: Kimberley Perry
To: Computer Tech Tips
Posted: Sep 19, 2014 12:43 PM
Subject: RE: Word 2010 - issues with merge codes
Message:
Oops, yes, Catherine is correct, it is DDE, not ODBC. I have had issues though with some spreadsheets where I've had to try most of the choices to get it to work (three identical spreadsheets and DDE work for two of them and we could only get the OLE to work for the third one, which was kinda weird).

-------------------------------------------
Kim 
-------------------------------------------


Show Original Message
Be the first person to recommend this.


8.
RE: Word 2010 - issues with merge codes
From: Kimberley Perry
To: Computer Tech Tips
Posted: Sep 19, 2014 12:39 PM
Subject: RE: Word 2010 - issues with merge codes
Message:
Hi Krista,

Following is the procedure to mail merge (Excel data and Word main document) so that the Excel "number" formatting remains intact (i.e., currency, dates formatted the way they are in Excel, etc.):

1) In Word, you need to change one of the options/settings that will prompt you to confirm "how" the Excel data is converted when you choose your data source file:  In Word (doesn't matter what document is open, if any) select File > Options > Advanced, scroll down near the bottom, under the "General" group of options, select the check box "Confirm file format conversion on open".
2) Open your Word merge "main document".
3) The you must "re-open / find your data source" again so that you will get prompted to select the type of file conversion (per the setting you turned on in step 1 above). On the 'Mailing' ribbon, "Select Recipients / Use Existing List" (or however you find and 'connect' your Excel data to the Word document).
4) Once you select and open your Excel file/data source, a dialog box/prompt will open called "Confirm Data Source", the first time around you may have to select the "Show All" check box at the bottom left to see the one you need to use; the data source you need to select, in order for all Excel number formatting to remain as it is in Excel is: "Excel Files via ODBC" (the key is ODBC, which stands for Object DataBase Connectivity).

Hope this works for you and good luck with your merge.

Best Regards,

Kim
-------------------------------------------
Kim Perry, CAP-OM, MOS Master 2010, Microsoft Certified Trainer
Vancouver Chapter
-------------------------------------------


Show Original Message
1 person recommends this.


9.
RE: Word 2010 - issues with merge codes
From: Catherine Scribner
To: Computer Tech Tips
Posted: Sep 19, 2014 8:56 AM
Subject: RE: Word 2010 - issues with merge codes
Message:
The problem you are having has to do with the way Word is translating the information coming from Excel, so making changes in the Excel data does not work.  You need to change the settings in Word. 

Here is what you need to do:

Word 2007 and Word 2010
  1. Start Word, and then open a new blank document.
  2. Go to Word Options
    • In Word 2007, click the Office Button, and then click Word Options.
    • In Word 2010, click File, and then click Options.
  3. On the Advanced tab, go to the General section.
  4. Click to select the Confirm file format conversion on open check box, and then click OK.
  5. On the Mailings tab, click Start Mail Merge, and then select Step By Step Mail Merge Wizard.
  6. In the Mail Merge task pane, select the type of document that you want to work on, and then click Next.
  7. Under Select starting document, select the starting document that you want to use, and then click Next.
  8. Under Select recipients, click Use an existing list, and then click Browse.
  9. In the Select Data Source dialog box, locate the folder that contains the Excel workbook that you want to use as your data source, select the workbook, and then click Open.
  10. In the Confirm Data Source dialog box, click to select the Show all check box. Click MS Excel Worksheets via DDE (*.xls), and then click OK.

NOTE: Your data now will now appear in the Mail Merge Recipients dialog box with the same formatting that appears in the Excel worksheet.

You do not need to do this every time you do a mail merge from Excel.  Once you have set this up, the Data Source formatting is saved to your Normal template and so it will carry over to your future documents automatically.

Hope this helps :)

Catherine
-------------------------------------------
Catherine Scribner, CAP-OM
Executive Administrative Assistant
Portland, ME

-------------------------------------------


Show Original Message
2 people recommend this.


10.
RE: Word 2010 - issues with merge codes
From: Wendy Fan
To: Computer Tech Tips
Posted: Sep 18, 2014 10:01 AM
Subject: RE: Word 2010 - issues with merge codes
Message:
Krista,
When you copy and paste your data from Excel, did you paste it as "values" (123) or you just simply paste it.  For some reason,it does make a difference in formatting later on if you choose to paste your data as "values" rather than in some other format.  Try to see if it works.
Wendy

-------------------------------------------
Wendy Fan CAP-OM
Admin Supervisor and Executive Assistant
Richmond Hill, ON
-------------------------------------------


Show Original Message
Be the first person to recommend this.