Email and Distribution Lists to send Reports thru email

G

Guest

Hi

I have an App where a user can design a email message and add Attachments
and send to a list of email addresses they manually enter
into a grid- no problem all is working

I have to add functionality of Distribution list
so I need to maintain
1)list of emails
2)Groups that contain multiple emails addressses

I have a table design there I have 1 table which contains distribution list
and it points to 2nd table of email addresses. Distribution List ID=0 is
an email with no distribution list


This seems ok but now I have a mental block - I want to design a form
with a grid where I will have a dropdownlist in the grid row that will
display
any email with ID=0 and all the distribution list.
So when the user picks a email address it gets added but if they pick a
distribution list I need to get all the emails from that list

Am I making this over- complicated or is there an easier design I should use

Thanks

Drop Down List would look like:
(e-mail address removed)
(e-mail address removed)
Company ABC List
Company XYZ List

tab1

id list name
0 No List
1 Company ABC List
2 Company XYZ List


tab2

id email address
0 (e-mail address removed)
0 (e-mail address removed)
1 (e-mail address removed)
2 tom @companyxyz.com
 
P

Peter Yang [MSFT]

Hello,

I think the table design you use shall be appropriate. You may want to add
a new query as the source of the dropdown list, and use some code to get
the proper email addresses when selecting a item from the dropdownlist.

The tab1 has 1 to many relation with tab2 but id 0 need to be handled
differently on the application level. However, this shall not affect the
design of the table directly.

If yhou have any further questions or comments, please feel free to let's
know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top