By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,680 Members | 1,578 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,680 IT Pros & Developers. It's quick & easy.

Emailing to multiple people

P: n/a
First - I don't know VBA very well at all.

I have report that I want to email to multiple users that give them the
quantities of their Inventory parts only. So I need something that will loop
through each user and send them a report (as an attachment) with only their
information in it.

There are about 60 people to email to. I have used the macro send command but
that allows for only static name at a time...so it won't work for these
purposes.

Anyway I can get this done without knowing VBA very well?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1

Jun 22 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
If you want to send people 60 reports with only their own information shown,
you will have to run the report 60 times, probably with a parameter for each
user. Not difficult, but by the time you are done you will know VBA better
than you know it now. Don't try to do this with a Macro. While it would be
possible, it would be like building a ship in a bottle.

Good luck,

Gary

"szag via AccessMonster.com" <u2885@uwewrote in message
news:741435146f86f@uwe...
First - I don't know VBA very well at all.

I have report that I want to email to multiple users that give them the
quantities of their Inventory parts only. So I need something that will loop
through each user and send them a report (as an attachment) with only their
information in it.

There are about 60 people to email to. I have used the macro send command
but
that allows for only static name at a time...so it won't work for these
purposes.

Anyway I can get this done without knowing VBA very well?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1

Jun 22 '07 #2

P: n/a
If you want to send people 60 reports with only their own information shown,
you will have to run the report 60 times, probably with a parameter for each
user. Not difficult, but by the time you are done you will know VBA better
than you know it now. Don't try to do this with a Macro. While it would be
possible, it would be like building a ship in a bottle.

Good luck,

Gary

"szag via AccessMonster.com" <u2885@uwewrote in message
news:741435146f86f@uwe...
First - I don't know VBA very well at all.

I have report that I want to email to multiple users that give them the
quantities of their Inventory parts only. So I need something that will loop
through each user and send them a report (as an attachment) with only their
information in it.

There are about 60 people to email to. I have used the macro send command
but
that allows for only static name at a time...so it won't work for these
purposes.

Anyway I can get this done without knowing VBA very well?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1

Jun 22 '07 #3

P: n/a
Thanks Gary - Any advice on how to get started without really knowing VBA at
all? Is it best to find similiar code and try to work it into my example?

Gary Floam wrote:
>If you want to send people 60 reports with only their own information shown,
you will have to run the report 60 times, probably with a parameter for each
user. Not difficult, but by the time you are done you will know VBA better
than you know it now. Don't try to do this with a Macro. While it would be
possible, it would be like building a ship in a bottle.

Good luck,

Gary
>First - I don't know VBA very well at all.
[quoted text clipped - 9 lines]
>>
Anyway I can get this done without knowing VBA very well?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1

Jun 22 '07 #4

P: n/a
Hi,
Thanks Gary - Any advice on how to get started without really knowing
VBA at all? Is it best to find similiar code and try to work it into
my example?
There are two Access Archon Columns written by Helen Feddema, which could
help you starting :

http://www.helenfeddema.com/access.htm

Mass EMailings from an Access Table (accarch106.zip)
Mass Report Emailing (accarch135.zip)

Regards
Jens
Jun 22 '07 #5

P: n/a
Jens - this looks great. Thanks!

Jens Schilling wrote:
>Hi,
>Thanks Gary - Any advice on how to get started without really knowing
VBA at all? Is it best to find similiar code and try to work it into
my example?

There are two Access Archon Columns written by Helen Feddema, which could
help you starting :

http://www.helenfeddema.com/access.htm

Mass EMailings from an Access Table (accarch106.zip)
Mass Report Emailing (accarch135.zip)

Regards
Jens
--
Message posted via http://www.accessmonster.com

Jun 22 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.