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 5  2007 
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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jonathan M. Rose |
last post by:
I am looking for a script that I can sit on an HTML server (Linux,
Apache, PHP/Perl/Python/Etc.) that will allow me to do the following things:
1) Post news articles that consists of (i) a title...
|
by: Stanley Cheung |
last post by:
Hi all,
I am developing the application for send emailing list,
actually, i can perform to send a email 1 by 1 and do it on aspx page.
I have a enquiry that how can the application change to...
|
by: Chuck |
last post by:
I have a database that has a table in it with employee information (name,
dob, email, etc). This is joined to a table that has tasks that are
assigned to each individual that has a recurring date....
|
by: Colin Anderson |
last post by:
I discovered, with great excitement, this article
http://www.davison.uk.net/vb2notes.asp when researching methods for
emailing from Access via Notes. Unfortunatly, when I run this I get a...
|
by: Mike Moore |
last post by:
What is the best way to launch outlook from an asp.net web page? Can you do this using MAPI or is there a control that you can purchase? We are unable to use SMTP. We use MS Exhange and MAPI...
|
by: Elmo Watson |
last post by:
I'm having weird problems emailing on the Win2003 Staging
environment - -
the same script runs on multiple other computers, but on this
one, the smtp service is running, but when the send is done...
|
by: Will |
last post by:
Hey guys,
i need a code that will allow users to email to multiple people as well as add as many attachments as user likes, and will work with outlook express/ or microsoft outlook (any version)...
|
by: Tim Hunter |
last post by:
I have two questions regarding emailing from Access.
My first question relates to how many email addresses is too much. I
have a client who wants to email 1500 people at once. Is this possible
or...
|
by: colemanj4 |
last post by:
Hello,
I have a report that takes a person's name and shows any outstanding
jobs that are required of them. People are complaining that they don't
get proper notification when they have jobs...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
