[AccessD] Using Multidimensional Arrays

Penn White ecritt1 at alltel.net
Tue Mar 7 04:29:17 CST 2006


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 




More information about the AccessD mailing list