I have an Access database that has contact information for all of the Institutes employees. I also have a telephone/e-mail directory that is in the form of an excel spreadsheet.
i would like to intergrate the two of these to cut down on the number of things i need to update when people join/leave the institute, which happens frequently b/c we have 8-10 new interns every quarter.
the biggest issue is that i am unhappy with the output of the access database. it changes all emails to text by placing an ' as the first character in the cell when exported to excel, or doesn't include the a href tag when exporting it as an htm document. it defeats the purpose of doing it this way when i have to go through an change all of the cells with email addresses. in excel, i tried doing a seach for the ', but it doesn't come up becuase it is only visible in the formula bar.
also, i am not happy with the way the report looks. i usually spend 15 minutes adjusting it in design view before i like it. every time i add name, i need to go back and do this again because i can't update the report with designing it over (is there a way around this?)
any suggestion on what i should on?
i would like to intergrate the two of these to cut down on the number of things i need to update when people join/leave the institute, which happens frequently b/c we have 8-10 new interns every quarter.
the biggest issue is that i am unhappy with the output of the access database. it changes all emails to text by placing an ' as the first character in the cell when exported to excel, or doesn't include the a href tag when exporting it as an htm document. it defeats the purpose of doing it this way when i have to go through an change all of the cells with email addresses. in excel, i tried doing a seach for the ', but it doesn't come up becuase it is only visible in the formula bar.
also, i am not happy with the way the report looks. i usually spend 15 minutes adjusting it in design view before i like it. every time i add name, i need to go back and do this again because i can't update the report with designing it over (is there a way around this?)
any suggestion on what i should on?
