- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
To setup up contacts by the person's last name. In Outlook, when you compose a new message, and then click the To or Ccbutton, the Contacts list may display names that are sorted by the contact's first name. Here's how you can change the list to display entries by the contact's last name.
Sort the Contacts list by the File As field
On the Tools menu, click E-mail accounts.
Click View or change existing directories or address books, and then click Next.
Click Outlook Address Book, and then click Change.
Under Outlook Address Books, click Contacts: Mailbox -YourMailboxName, and then under Show names by, click File As (Smith, John).
Click Close, and then click Finish.
Verify that the newly created contacts are filed in last name, first name order
On the Tools menu, click Options.
Click the Preferences tab, and then click Contact Options.
In the Default "File As" order list, click Last, First.
Click OK twice.
To view the new Contacts list sort order, restart Outlook.
NOTE If you want to display a particular contact in a different order than the rest of the Contact list, you can modify the File As field in individual contact cards. For example, you may want to sort some contacts by the Company field.
once = True MyLine = "" MyLine = MyLine & ch MyLocation = Loc(1) Loop
MsgBox " File has been successfully imported! " Close #1 ' Close file. rs.Close
'close and erase the file from memory objText.Close Set objText = Nothing
Set rs = Nothing
have to follow few steps.
1. new database - give any name
--> design table
e.g id, name and file (the datatype of the file should be hyperlink other wise it wont work)
--> enter some records (in file field write a, b ,c)
--> when you put record in file field then click on hyperlink option on top.. (like first record id=1, name=fahad, file=A) select the A and click on hyperlink option on top and give the hyperlink of the pdf file
--> design the form
--> run the form
--> click on desired file
--> it will open
--> looks complicated but its easy
You need to set up security and different profiles for different people. that is the safest way. But an easier way is to have you enter data in one form and them enter their data in another form. In their form edit the properties of the fields that you want left alone. You need to set the properties to locked in the form where they do their data entry but leave them unlocked where you do your data entry. Just creat a second form by saving the first one under a different name. Also you might want to remove the fields from the tab stop list.
open your table in query, follow steps to do this...
1. open new query in access
2. locate the table
3. once table selected, select field name in selected table you only want to include in query
3. once finished selecting the field save the query
4. you can now view selected field in your table and print as well
5. you can edit the query anytime if you want to add or remove field
6. query will not affect your table since this is only query.
If the First Name and Last name are equal to both work sheets, I will just sort them by First Name and Last name and copy the results into a separate work sheet.
If the names are different you will have to use Access:
This can be easily done with Access and SQL, just import both work books into different tables to access and use the create query wizard, play with the results until you will get the result you want. Access will also solve the duplicate problem easily.
You will have to use join properties:
Read help about join properties and understand how this works...
Afterward you can export it back to Excel or use Copy/Paste.
If you can't use Access and have only Excel:
You will have to use Vlookup on various fields until you will get the result you want. Its a hard work but in the end you will get the same result as access.
Let me know what happend