Search results for query: *

Did you try to export the Access data into Excel (delete columns you don't want in Outlook) and save the file as a ".cvs", then import that file into Outlook? Sopman

When I open a .doc it shows all the changes that everyone has made in red. I'd like the .doc to open without showing the changes. I went to Tools-Options-Edit and removed the check mark in "Keep Track of Formatting". The .doc still opens showing the changes. Thanks Sopman

I have a field that contains email addresses. Is their a way to get the email addresses in access into Yahoo mail? I tried saving them in excel as a .csv file, but could not import them into yahoo mail. Sopman

I'm keeping the database for little league. In "Forms" I have fields labeled "birthday", "league age", and "Apr 15, 2007". What I would like to do is when the birthdate is enter I need that to subtract from Apr 15, 2007 to give me the league age of the player. Is there a way to calculate this...

I'm trying to transfer my MS Outlook Personnel Address Book (.PAB) into my Yahoo email account. I'm having troubles making the .PAB into a .CVS so that yahoo can import it. I don't want to import my "Contacts", just my Personnel Address Book. Can someone help me? Sopman

In my Excel spreadsheet I have a separate sheet that has the "Lookup" values. This sheet is called "Data". On a different sheet I have this command, =LOOKUP(K6,DATA!K5:K400:DATA!L5:L400) The value I had in K6 use to match up correctly with what was in the "Data" sheet. Everything worked...

Thank you for your replies. Ken, that works, because all numbers are >0. Skip, thanks for the explanation. I'll print that out for future reference. Sopman

Somedays have data in cells A1,A2,A3,A4,A5,A6 Somedays I have data in A1,A2 Somedays I have data in A1,A2,A3,A4 I'll always have data in A1 and as more data comes in it will go in the next cell, but the most data I will have will be in A1:A6. The least could be just in A1. I never know which...

Thank You. I'm still a rookie with these formulas. That line worked great. Sopman

Skip, I don't want to count. I never know how many rows of data I have and the last row of data I need to copy to B5. Sopman

Somedays have data in cells A1,A2,A3,A4,A5,A6 Somedays I have data in A1,A2 Somedays I have data in A1,A2,A3,A4 I'll always have data in A1 and as more data comes in it will go in the next cell, but the most data I will have will be in A1:A6. The least could be just in A1. I never know which...

Thanks you, I over looked that. I have another question that I'll post. Sopman

In cell "A1" I have a date "7/13/2006" In cell "B1" I have a time "1:45 PM" How do I combine both columns into one column with a "space" between the date and time? Thanks Sopman

Thanks Bluedragon2. That worked. Sopman

No, Skip did not answer my question. Numbers in Column A are numbers like; 4.8812, 4.8832, etc... I can't sort. Sopman

I have numbers in A1:48. Sorry about that. Sopman

In column 'A' I have numbers 1-48. Is there a way to reverse those number and put them into column 'B'? Can I use the Paste Special? Sopman

Thank You, that worked.

I have a spreadsheet that has the schedule of basketball games/practices for all teams. Is there a way to sort out just our team? We are team 5. In column E this is what it looks like: Game 2 & 5 Plus it has other teams playing: Game 3 & 4 Thanks Sopman

I'm trying to do the Search command "containing text", but having problems with the text I'm entering. It is ##.00 For some reason it doesn't like the #. I get a parameter error message. Is there anyway around this? Thanks Sopman