mass mailing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need to create a database in access with multiple addresses for one person,
but be able to select one as the primary address to send mail to, and having
the ability to change that in the future.

for example:
Bob Lamb has 3 addresses:
Home
Business
Country House

His default mailing address is home, but it will change to Business
eventually. Is there a way to create a drop down menu in order to default the
mailing adress??

Thanks so much for your help!!
 
1. In your contact table, tblContact, have one field with the primary e-mail
address: blnEMail
2. Store all e-mail addresses related to a contact (with categories) in
another table: tblContact_EMail Add boolean field e.g. blnPrimary to record
if e-mail is primary e-mail address.
3. Display tblContact_EMail data in a subform displaying a single record.
4. In Parent form Form_Current evaluate Me.subFormControl.Form.
RecordsetClone.RecordCount = 0. If True make default value for checkbox
bound to [blnPrimary] = True. Also disable the checkbox if the condition is
True, enable it if there is more than one e-mail record.
5. Finally, if the user edits the value in the check box update the
tblContact_EMail recordset so that there is always a tblContact_EMail record
with [blnPrimary]=True (loop through the subForms Me.RecordsetClone) and
update parent [tblContact].[blnEMail] to that tblContact_EMail record value.

This may seem like a lot of work, but the end result is that you only have
to return e-mail addresses from tblContact, and you can add as many e-mail
addresses as you like without having to change tblContact!
 
several approaches - but one that we have worked with:

a. have a field 'Active' (or 'Primary')which can be yes/no or
checkbox.....and then you can mail to only those Active or yes by simply
basing your mailing merge based on the data from a query that selects these
rather than based on the entire table....

to use the data from a query (rather than a table) is a standard option
within the mail merge
 
Oops I just re-read the post and realised I misread address. However, you
can do the same with addresses. In the tblContact have an aggregate address
field say memAddress. Enter address data in tblContact_Address (multiple
address records) and when the record is saved concatonate address fields
(Address 1, Address 2, Town, etc) and update tblContact.memAddress if the
checkbox bound to blnPrimary displays True... If this changes, update the
subForm recordset as below, and update the parent tblContact.memAddress with
concatonated value of the new record where tblContact_Address.blnPrimary =
True.
1. In your contact table, tblContact, have one field with the primary e-mail
address: blnEMail
2. Store all e-mail addresses related to a contact (with categories) in
another table: tblContact_EMail Add boolean field e.g. blnPrimary to record
if e-mail is primary e-mail address.
3. Display tblContact_EMail data in a subform displaying a single record.
4. In Parent form Form_Current evaluate Me.subFormControl.Form.
RecordsetClone.RecordCount = 0. If True make default value for checkbox
bound to [blnPrimary] = True. Also disable the checkbox if the condition is
True, enable it if there is more than one e-mail record.
5. Finally, if the user edits the value in the check box update the
tblContact_EMail recordset so that there is always a tblContact_EMail record
with [blnPrimary]=True (loop through the subForms Me.RecordsetClone) and
update parent [tblContact].[blnEMail] to that tblContact_EMail record value.

This may seem like a lot of work, but the end result is that you only have
to return e-mail addresses from tblContact, and you can add as many e-mail
addresses as you like without having to change tblContact!
i need to create a database in access with multiple addresses for one person,
but be able to select one as the primary address to send mail to, and having
Click to expand...
[quoted text clipped - 11 lines]
Thanks so much for your help!!
Click to expand...
Click to expand...
 
Correct database design dictates the address should be in a child table to
the person table if there will be multiple addresses. Here is a suggested
structure:

tblPersonAddress
ADDR_ID - AutoNumber PK
PERSON_ID - Long FK to person table
ADDR_1 - Text 30
ADDR_2 - Text 30
CITY - Text 20
STATE - Text 2 (Assumes U. S. Addresses)
ZIP_CODE - Text 9
ADDR_TYPE - Long FK to Address Types table
ADDR_DEFAULT - Yes/No - Default to No

The Address Type table can be used as a record source for a combo on your
form to enter the address type (Home, Office, Wife's Address, Girl Friend's
Address)

Then create a query on those tables to use as the recordset for a subform.
You can make one of the addresses the default address by changing it from No
to Yes. You will also have to run some code or a query that will change all
the others for the person to No.
 
Sorry, but this is a really bad idea.

IanOxon via AccessMonster.com said:
Oops I just re-read the post and realised I misread address. However, you
can do the same with addresses. In the tblContact have an aggregate address
field say memAddress. Enter address data in tblContact_Address (multiple
address records) and when the record is saved concatonate address fields
(Address 1, Address 2, Town, etc) and update tblContact.memAddress if the
checkbox bound to blnPrimary displays True... If this changes, update the
subForm recordset as below, and update the parent tblContact.memAddress with
concatonated value of the new record where tblContact_Address.blnPrimary =
True.
1. In your contact table, tblContact, have one field with the primary e-mail
address: blnEMail
2. Store all e-mail addresses related to a contact (with categories) in
another table: tblContact_EMail Add boolean field e.g. blnPrimary to record
if e-mail is primary e-mail address.
3. Display tblContact_EMail data in a subform displaying a single record.
4. In Parent form Form_Current evaluate Me.subFormControl.Form.
RecordsetClone.RecordCount = 0. If True make default value for checkbox
bound to [blnPrimary] = True. Also disable the checkbox if the condition is
True, enable it if there is more than one e-mail record.
5. Finally, if the user edits the value in the check box update the
tblContact_EMail recordset so that there is always a tblContact_EMail record
with [blnPrimary]=True (loop through the subForms Me.RecordsetClone) and
update parent [tblContact].[blnEMail] to that tblContact_EMail record value.

This may seem like a lot of work, but the end result is that you only have
to return e-mail addresses from tblContact, and you can add as many e-mail
addresses as you like without having to change tblContact!
i need to create a database in access with multiple addresses for one person,
but be able to select one as the primary address to send mail to, and having
Click to expand...
[quoted text clipped - 11 lines]
Thanks so much for your help!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top