I am designing a new database which previously was a flat file table. I have broken this flat file down into four tables but they do not seem to be linking (using queries) very well.
I do not know if I am designing the tables properly. Table 1 is Organisation Information, ie address, etc...
I think i could do this by using the results from a query to display the emails in a listbox but i am unsure how to seperate my reults in the list box by commas so that i can use it as a multiple Email....
Sorry about the delay in answering. I think you can use combo boxes with your subjects displayed and put it in your exhisting code like this, if your email cc field is called
"Cc" and your subject field is called "Subject" your code would look like this
Private Sub...
what i was hoping to do, if i can was to use my working groups table to display all the email addresses for people in that group, then with all the email addresses displayed in a text box to press a command button to send the email.
The working group members change frequently so i was wanting to...
I think you can use any name, it is just for your reference when you are looking at your mail or if you have several mail accounts on the one computer.What you will need however is your incoming and outgoing server information for your email account for example pop3(incoming mail) for a ntl...
The field be set to text.When you place a command button and it requests you to take an option press cancel.You can now enter the code in the onclick event procedure
i renamed my button "cmdemail" so my code looks like this
Private Sub cmdemail_Click()
On Error Resume Next...
I have a table with around 300 contacts, each contact has an email address.I have 8 working groups that i would like to email news and events to. I was wanting to design a form with a drop down list of the 8 working groups or 8 seperate command buttons that when each group is selected it...
I have recently had help here with the same problem, don't know if this helps you but here goes...i have a feild called "EmailName1" that contains my contacts email address, i then made a command button beside the field and in the onclick event procedure i entered this code:
Private...
I am creating a new database and am unsure which is the best method for creating a primary key from the fields I have availble. From table 1 I have firstname, surname, jobtitle. Can I use another field from another table (table 2)'organisation'. (Table 2 uses the autonumber).
Note. I do not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.