S
Stilty
In Outlook 2002, I need to create email distribution lists sorted by building
number. I have created a query in my company's employee database (Access
2003) that sorts employees' emails by building number. I'm stuck trying to
figure out a way to create a live link from Access to Outlook.
For now, I can just open the query, specify a building, copy all the
employees' emails and copy onto a distribution list in Outlook. This is time
consuming and not foolproof if my boss is trying to send a building specific
email.
Another way I'm exploring is using Word as an interface:
1) Create the email message in Word,
2) Use mail merge to link the document to the appropriate Access query as a
data source
3) Checkbox the recipients associated with the desired building numbers and
then
4) Hitting the "Merge to Email" button, to send the message as an html.
This clutters up my "Sent Mail" because every recipient gets his/her own
email.
Ideally, in Access, I'd like to create a query that has "building" in one
field, and the other has the "Email Distribution List" consisting of all the
emails recipients in the specified building. So each building is only
composed of one value--the distribution list, instead of one value for every
recipient. After the value is all one value, I'll need a way to efficiently
live link it to Access.
I think this is the missing piece of the puzzle. If you know of a piece
that's a better fit, I'd love to hear it!
number. I have created a query in my company's employee database (Access
2003) that sorts employees' emails by building number. I'm stuck trying to
figure out a way to create a live link from Access to Outlook.
For now, I can just open the query, specify a building, copy all the
employees' emails and copy onto a distribution list in Outlook. This is time
consuming and not foolproof if my boss is trying to send a building specific
email.
Another way I'm exploring is using Word as an interface:
1) Create the email message in Word,
2) Use mail merge to link the document to the appropriate Access query as a
data source
3) Checkbox the recipients associated with the desired building numbers and
then
4) Hitting the "Merge to Email" button, to send the message as an html.
This clutters up my "Sent Mail" because every recipient gets his/her own
email.
Ideally, in Access, I'd like to create a query that has "building" in one
field, and the other has the "Email Distribution List" consisting of all the
emails recipients in the specified building. So each building is only
composed of one value--the distribution list, instead of one value for every
recipient. After the value is all one value, I'll need a way to efficiently
live link it to Access.
I think this is the missing piece of the puzzle. If you know of a piece
that's a better fit, I'd love to hear it!