Forum Discussion
basic help: how to sort a mail merge address list
Hi we are working on sending out letters and have a mailmerge list of names and addresses. every piece of data is int a separate column on the same row. how do we sort the list alphabetically by la...
Hello,
The example you mentioned and as I understand it should not only be better created with a database instead of Excel, but it is actually an Access solution.
Excel has the advantage that it is used by many and can quickly create simple tables. As soon as you need look-up values (activities for this customer, insert telephone, etc.), you should switch from Excel to Access as a matter of urgency. For this you need a real database with 1: n relationships and better form capabilities.
There may be ShareWare solutions that already meet your needs, but the more extensive your requirements, the safer there is a lot of work (and therefore costs) involved.
Unless someone here has already made a solution in this direction that he would like to share.
Nikolino
I know that I don't know (Socrates)
The example you mentioned and as I understand it should not only be better created with a database instead of Excel, but it is actually an Access solution.
Excel has the advantage that it is used by many and can quickly create simple tables. As soon as you need look-up values (activities for this customer, insert telephone, etc.), you should switch from Excel to Access as a matter of urgency. For this you need a real database with 1: n relationships and better form capabilities.
There may be ShareWare solutions that already meet your needs, but the more extensive your requirements, the safer there is a lot of work (and therefore costs) involved.
Unless someone here has already made a solution in this direction that he would like to share.
Nikolino
I know that I don't know (Socrates)