I am very new here. Please forgive me if this is not the right place to post this. I have a mailing list database in Filemaker 7. I have had it for some time and now I need to make one change and I am hoping there is a simple way to do it.
In this database I have one field for "First Name" and one field for "Last Name" In the "First Name" field I have always just put the title in there as well. Like Mr. or Mrs. or Rev. etc. Well I want to set up some letters to use mail merge and the way my database is now if I select the "First Name" field to begin a letter it would put Dear Mr. Bob instead of Dear Bob. I need to create a new "Title" field and separate the titles from the first names in the current "First Name" field.
My database has over 3,000 contacts and I am really hoping there is a simple or automated way to do this.
Thank you very much for any help!