DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Mar 7 09:50:55 CST 2006
Sounds like a Class and Collection would be easier to use here. Unless you are going for supreme processing speed, that is the way I would go. Drew -----Original Message----- From: Penn White [mailto:ecritt1 at alltel.net] Sent: Tuesday, March 07, 2006 4:29 AM To: Access Developers discussion and problem solving Subject: [AccessD] Using Multidimensional Arrays ACC03 - I'm sending out emails from Access to a list of recipients selected from a listbox. Since I don't have Exchange Server, I can't be sure that the entries in the 'workstations' Outlook Contact list is up-to-date. Consequently, I have to verity first that the Contact is in that workstation's Outlook Contact list and second that the email address hasn't changed. It's a bit messy and may be time consuming since every single email will have to check all the recipients before being sent but there would rarely be more than 10 recipients for an email and more usually only 2-3 and I can't think of any other way to do it. I was thinking of creating a multi-dimensional array to hold the FirstName, LastName and Email address for each selected recipient but I can't figure out how to do it. The number of entries in the array will vary depending on how many recipients are selected. There may not necessarily be a first name and the 'last name' may actually be a string of several words, like "Belton Manufacturing" for example. Once the array is created, I'll need to concatenate the first and last names and check them against the existing entries in Outlook Contacts, updating or adding as necessary. If I can get the entries out of the array, that won't be hard, I've already done if before and have developed functions for the various pieces. I've also seen some comparisons between using structures and arrays and maybe I should be using a structure here. I'm a bit befuddled. Penn -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com