Help Email Marco with the Senobject function

[Mortsiefer, Markus]

Hallo

I hope some one can help me I have the following problem I have a report
that I would like to send out as a snapshot to a list of people that I
maintain in a Table.
The problem I am having is to send it to more then one person at a time I do
not know hot to link the sendobject to a table list of people to send the
report to.
I hope some one can give me a idea on how to do this

 

[Jim/Chris]

I have had a need to send a report to multiple
recipients(which changes) so I setup a form with the following
combobox(Combo3) listing email addresses
An unbound text box(emailadd) to store the email addresses
a command button to run a macro that emails the report
using the unbound text box for the sendto.

In the afterupdate event of the combo box I have this code
Me.emailadd = Me.Combo3 & ";" & Me.emailadd
This will append each selected email address to the
preveous ones selected in the unbound text box(emailadd)


In the sendreport macro use
=[Forms]![NameOfForm]![emailadd] for the sendto


Good Luck

Jim

 

[Mortsiefer, Markus]

Thank you Jim

It is a good idea but this does not work because I have about 100 people
that I send this report to and with your way I would have to click on all
hundred people in the combo box. Is there not a way it can be done with out
me clicking on the names in the combo box.

I have had a need to send a report to multiple
recipients(which changes) so I setup a form with the following
combobox(Combo3) listing email addresses
An unbound text box(emailadd) to store the email addresses
a command button to run a macro that emails the report
using the unbound text box for the sendto.

In the afterupdate event of the combo box I have this code
Me.emailadd = Me.Combo3 & ";" & Me.emailadd
This will append each selected email address to the
preveous ones selected in the unbound text box(emailadd)


In the sendreport macro use
=[Forms]![NameOfForm]![emailadd] for the sendto


Good Luck

Jim

-----Original Message-----
Hallo

I hope some one can help me I have the following problem I have a report
that I would like to send out as a snapshot to a list of people that I
maintain in a Table.
The problem I am having is to send it to more then one person at a time I do
not know hot to link the sendobject to a table list of people to send the
report to.
I hope some one can give me a idea on how to do this


.

 

[Jim/Chris]

You might want to look at
http://www.granite.ab.ca/access/email.htm

Jim

-----Original Message-----
Thank you Jim

It is a good idea but this does not work because I have about 100 people
that I send this report to and with your way I would have to click on all
hundred people in the combo box. Is there not a way it can be done with out
me clicking on the names in the combo box.

I have had a need to send a report to multiple
recipients(which changes) so I setup a form with the following
combobox(Combo3) listing email addresses
An unbound text box(emailadd) to store the email addresses
a command button to run a macro that emails the report
using the unbound text box for the sendto.

In the afterupdate event of the combo box I have this code
Me.emailadd = Me.Combo3 & ";" & Me.emailadd
This will append each selected email address to the
preveous ones selected in the unbound text box(emailadd)


In the sendreport macro use
=[Forms]![NameOfForm]![emailadd] for the sendto


Good Luck

Jim

-----Original Message-----
Hallo

I hope some one can help me I have the following problem I have a report
that I would like to send out as a snapshot to a list of people that I
maintain in a Table.
The problem I am having is to send it to more then one person at a time I do
not know hot to link the sendobject to a table list of people to send the
report to.
I hope some one can give me a idea on how to do this


.

.

 

[Jim/Chris]

You could create groups in outlook and reference that group
in your sendto paramater

Jim

-----Original Message-----
Thank you Jim

It is a good idea but this does not work because I have about 100 people
that I send this report to and with your way I would have to click on all
hundred people in the combo box. Is there not a way it can be done with out
me clicking on the names in the combo box.

I have had a need to send a report to multiple
recipients(which changes) so I setup a form with the following
combobox(Combo3) listing email addresses
An unbound text box(emailadd) to store the email addresses
a command button to run a macro that emails the report
using the unbound text box for the sendto.

In the afterupdate event of the combo box I have this code
Me.emailadd = Me.Combo3 & ";" & Me.emailadd
This will append each selected email address to the
preveous ones selected in the unbound text box(emailadd)


In the sendreport macro use
=[Forms]![NameOfForm]![emailadd] for the sendto


Good Luck

Jim

-----Original Message-----
Hallo

I hope some one can help me I have the following problem I have a report
that I would like to send out as a snapshot to a list of people that I
maintain in a Table.
The problem I am having is to send it to more then one person at a time I do
not know hot to link the sendobject to a table list of people to send the
report to.
I hope some one can give me a idea on how to do this


.

.

 

[Mortsiefer, Markus]

Hi Jim

Thank you again for your ideas is there a way with out clicking on a list
box to add it into a text box, Or is there a way of getting the information
from with a query maybe. Your idea with making a group list in Outlook is
the way I am doing it now but the problem is I am not just the only one
using it and at the moment we are having problems keeping the group list in
sync that's why I want to have it all in Access. I Hope you have any more
clever ideas I really appreciate your help.

Markus

You could create groups in outlook and reference that group
in your sendto paramater

Jim

-----Original Message-----
Thank you Jim

It is a good idea but this does not work because I have about 100 people
that I send this report to and with your way I would have to click on all
hundred people in the combo box. Is there not a way it can be done with out
me clicking on the names in the combo box.

I have had a need to send a report to multiple
recipients(which changes) so I setup a form with the following
combobox(Combo3) listing email addresses
An unbound text box(emailadd) to store the email addresses
a command button to run a macro that emails the report
using the unbound text box for the sendto.

In the afterupdate event of the combo box I have this code
Me.emailadd = Me.Combo3 & ";" & Me.emailadd
This will append each selected email address to the
preveous ones selected in the unbound text box(emailadd)


In the sendreport macro use
=[Forms]![NameOfForm]![emailadd] for the sendto


Good Luck

Jim
-----Original Message-----
Hallo

I hope some one can help me I have the following problem I
have a report
that I would like to send out as a snapshot to a list of
people that I
maintain in a Table.
The problem I am having is to send it to more then one
person at a time I do
not know hot to link the sendobject to a table list of
people to send the
report to.
I hope some one can give me a idea on how to do this


.

.

 

[Jim/Chris]

Ok, Here is another way based on the first method I showed
you. Create/maintain you email distribution list in a
table in Access. The table will consist of group name and
series of email addresses seperated by ";". This table
will be maintained by a designated person or you could let
anyone add addresses to it. Your combo box will be a list
of groups. After selecting that group Your unbound text
box will populated using the DLookup command. That will
be used in your "sendto". Remember unbound text boxes are
limited to 255 characters. You might have to define it as
a memo field. I haven't tried using a memo field in this
manner.

Jim

-----Original Message-----
Hi Jim

Thank you again for your ideas is there a way with out clicking on a list
box to add it into a text box, Or is there a way of getting the information
from with a query maybe. Your idea with making a group list in Outlook is
the way I am doing it now but the problem is I am not just the only one
using it and at the moment we are having problems keeping the group list in
sync that's why I want to have it all in Access. I Hope you have any more
clever ideas I really appreciate your help.

Markus

You could create groups in outlook and reference that group
in your sendto paramater

Jim

-----Original Message-----
Thank you Jim

It is a good idea but this does not work because I have about 100 people
that I send this report to and with your way I would have to click on all
hundred people in the combo box. Is there not a way it can be done with out
me clicking on the names in the combo box.


I have had a need to send a report to multiple
recipients(which changes) so I setup a form with the following
combobox(Combo3) listing email addresses
An unbound text box(emailadd) to store the email addresses
a command button to run a macro that emails the report
using the unbound text box for the sendto.

In the afterupdate event of the combo box I have this code
Me.emailadd = Me.Combo3 & ";" & Me.emailadd
This will append each selected email address to the
preveous ones selected in the unbound text box(emailadd)


In the sendreport macro use
=[Forms]![NameOfForm]![emailadd] for the sendto


Good Luck

Jim
-----Original Message-----
Hallo

I hope some one can help me I have the following problem I
have a report
that I would like to send out as a snapshot to a list of
people that I
maintain in a Table.
The problem I am having is to send it to more then one
person at a time I do
not know hot to link the sendobject to a table list of
people to send the
report to.
I hope some one can give me a idea on how to do this


.



.

.

 

[Mortsiefer, Markus]

Hi Jim

I have tryd this but i dont fully understand how to do it if you can explane
it a more detail and where and how i have to use the Dlookup that would be a
greate help sorry if i bug you so much

Markus

Ok, Here is another way based on the first method I showed
you. Create/maintain you email distribution list in a
table in Access. The table will consist of group name and
series of email addresses seperated by ";". This table
will be maintained by a designated person or you could let
anyone add addresses to it. Your combo box will be a list
of groups. After selecting that group Your unbound text
box will populated using the DLookup command. That will
be used in your "sendto". Remember unbound text boxes are
limited to 255 characters. You might have to define it as
a memo field. I haven't tried using a memo field in this
manner.

Jim

-----Original Message-----
Hi Jim

Thank you again for your ideas is there a way with out clicking on a list
box to add it into a text box, Or is there a way of getting the information
from with a query maybe. Your idea with making a group list in Outlook is
the way I am doing it now but the problem is I am not just the only one
using it and at the moment we are having problems keeping the group list in
sync that's why I want to have it all in Access. I Hope you have any more
clever ideas I really appreciate your help.

Markus

You could create groups in outlook and reference that group
in your sendto paramater

Jim

-----Original Message-----
Thank you Jim

It is a good idea but this does not work because I have
about 100 people
that I send this report to and with your way I would have
to click on all
hundred people in the combo box. Is there not a way it can
be done with out
me clicking on the names in the combo box.


message
I have had a need to send a report to multiple
recipients(which changes) so I setup a form with the
following
combobox(Combo3) listing email addresses
An unbound text box(emailadd) to store the email addresses
a command button to run a macro that emails the report
using the unbound text box for the sendto.

In the afterupdate event of the combo box I have this code
Me.emailadd = Me.Combo3 & ";" & Me.emailadd
This will append each selected email address to the
preveous ones selected in the unbound text box(emailadd)


In the sendreport macro use
=[Forms]![NameOfForm]![emailadd] for the sendto


Good Luck

Jim
-----Original Message-----
Hallo

I hope some one can help me I have the following problem I
have a report
that I would like to send out as a snapshot to a list of
people that I
maintain in a Table.
The problem I am having is to send it to more then one
person at a time I do
not know hot to link the sendobject to a table list of
people to send the
report to.
I hope some one can give me a idea on how to do this


.



.

.

 

[Jim/Chris]

This is after you have created your emailaddresstable with
the following fields
Groupname
emailaddress

The purpose of the combo box is to determine which group to
choose from. Allows for flexibility having different groups.

You would stack you emailaddress field like this
(e-mail address removed);[email protected];[email protected]

The dlookup command for the unbound text box is.
=DLookUp("emailaddress","emailaddresstable","[groupname] =
Form![comboboxname] ")

Jim

-----Original Message-----
Hi Jim

I have tryd this but i dont fully understand how to do it if you can explane
it a more detail and where and how i have to use the Dlookup that would be a
greate help sorry if i bug you so much

Markus

Ok, Here is another way based on the first method I showed
you. Create/maintain you email distribution list in a
table in Access. The table will consist of group name and
series of email addresses seperated by ";". This table
will be maintained by a designated person or you could let
anyone add addresses to it. Your combo box will be a list
of groups. After selecting that group Your unbound text
box will populated using the DLookup command. That will
be used in your "sendto". Remember unbound text boxes are
limited to 255 characters. You might have to define it as
a memo field. I haven't tried using a memo field in this
manner.

Jim

-----Original Message-----
Hi Jim

Thank you again for your ideas is there a way with out clicking on a list
box to add it into a text box, Or is there a way of getting the information
from with a query maybe. Your idea with making a group list in Outlook is
the way I am doing it now but the problem is I am not just the only one
using it and at the moment we are having problems keeping the group list in
sync that's why I want to have it all in Access. I Hope you have any more
clever ideas I really appreciate your help.

Markus
You could create groups in outlook and reference that group
in your sendto paramater

Jim

-----Original Message-----
Thank you Jim

It is a good idea but this does not work because I have
about 100 people
that I send this report to and with your way I would have
to click on all
hundred people in the combo box. Is there not a way it can
be done with out
me clicking on the names in the combo box.


message
I have had a need to send a report to multiple
recipients(which changes) so I setup a form with the
following
combobox(Combo3) listing email addresses
An unbound text box(emailadd) to store the email addresses
a command button to run a macro that emails the report
using the unbound text box for the sendto.

In the afterupdate event of the combo box I have this code
Me.emailadd = Me.Combo3 & ";" & Me.emailadd
This will append each selected email address to the
preveous ones selected in the unbound text box(emailadd)


In the sendreport macro use
=[Forms]![NameOfForm]![emailadd] for the sendto


Good Luck

Jim
-----Original Message-----
Hallo

I hope some one can help me I have the following problem I
have a report
that I would like to send out as a snapshot to a list of
people that I
maintain in a Table.
The problem I am having is to send it to more then one
person at a time I do
not know hot to link the sendobject to a table list of
people to send the
report to.
I hope some one can give me a idea on how to do this


.



.



.

.