Hello,

I have been asked to create a system that will allow staff to print address
labels for different groups of people through the Intranet. At the moment,
as it is a small company, staff create their own address tables/databases in
either access or word- but this means that everyone has their own source of
information and it is usually out of date. I have now moved our whole
employee database that was in Access into SQL, and would like all staff to
use this one source of information. Ultimately, the request has been that
staff should be able to, through the intranet, create ad hoc groups of
addresses and print these onto labels for mailouts. However, I know this
means me writing some sort of ASP/SQL based program- and due to my
restrictive time line, I wouldn't mind looking at other ways. However, if
the application is the only way, I'll do it.

Originally, my idea was to create a linked table in Access (that links to
the SQL employee database and therefore stays up-to-date) and give everyone
access to this source. The good thing here is that people can stay in Access
without having to learn something new, the address info is always up to date
and especially, is not hard for me to set up. The downfall is that, one, I
would have to create the linked table on each persons machine and two, I
don't know if Access can handle this especially over a network connection,
and potentially over long distances if our remote sites are to use this
database.

Does anyone have any suggestions, whatever they be I would be interested to
here them. It would be especially helpful if someone has actually created a
system like this before or is using one at the moment. If the suggestion is
that I do write the ASP system, please pass it on as well.

Thanks a lot
Neile

--

Neile Bermudes
Network Support Analyst
ECB IT Dept
020 74321241



The contents of this e-mail are the property of the ECB.  This e-mail (and any attachments) 
are confidential and intended for use by the named recipient(s) only.  It may contain 
confidential or privileged information.  Any opinions expressed herein are those of the 
individual and not necessarily those of the ECB. If you are not the intended recipient would 
you please immediately delete this e-mail and any attachments from your computer system 
without publishing, copying or distributing it, and notify the sender at the ECB.  Do not 
disclose this e-mail or the information disclosed herein to any other person, use it for any 
purpose other than intended, or copy, distribute or store the information on any medium. 
Copyright in this e-mail and attachments created by us belong to ECB and the author also 
asserts the right to be identified as such and to prevent any misuse.  Please conduct your 
own virus checks.  The ECB does not accept responsibility or liability for any virus or any 
loss or damage caused by such software virus.  Our web site is at http://www.ecb.co.uk.

HI,

If you are using asp application then why do you want your users to learn
the SQL or Access database? When you make asp program to do all jobs like
printing address's and else things then your users should know how to
operate your asp program not sql or any others database. I hope this would
make clear to you if not do write more about your application.

Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar,  Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Neile Bermudes" <Neile.Bermudes@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, February 05, 2003 11:54 AM
Subject: [asp_databases] Ability to print address labels through Intranet


> Hello,
>
> I have been asked to create a system that will allow staff to print
address
> labels for different groups of people through the Intranet. At the moment,
> as it is a small company, staff create their own address tables/databases
in
> either access or word- but this means that everyone has their own source
of
> information and it is usually out of date. I have now moved our whole
> employee database that was in Access into SQL, and would like all staff to
> use this one source of information. Ultimately, the request has been that
> staff should be able to, through the intranet, create ad hoc groups of
> addresses and print these onto labels for mailouts. However, I know this
> means me writing some sort of ASP/SQL based program- and due to my
> restrictive time line, I wouldn't mind looking at other ways. However, if
> the application is the only way, I'll do it.
>
> Originally, my idea was to create a linked table in Access (that links to
> the SQL employee database and therefore stays up-to-date) and give
everyone
> access to this source. The good thing here is that people can stay in
Access
> without having to learn something new, the address info is always up to
date
> and especially, is not hard for me to set up. The downfall is that, one, I
> would have to create the linked table on each persons machine and two, I
> don't know if Access can handle this especially over a network connection,
> and potentially over long distances if our remote sites are to use this
> database.
>
> Does anyone have any suggestions, whatever they be I would be interested
to
> here them. It would be especially helpful if someone has actually created
a
> system like this before or is using one at the moment. If the suggestion
is
> that I do write the ASP system, please pass it on as well.
>
> Thanks a lot
> Neile
>
> --
>
> Neile Bermudes
> Network Support Analyst
> ECB IT Dept
> 020 74321241
>
>
>
> The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments)
> are confidential and intended for use by the named recipient(s) only.  It
may contain
> confidential or privileged information.  Any opinions expressed herein are
those of the
> individual and not necessarily those of the ECB. If you are not the
intended recipient would
> you please immediately delete this e-mail and any attachments from your
computer system
> without publishing, copying or distributing it, and notify the sender at
the ECB.  Do not
> disclose this e-mail or the information disclosed herein to any other
person, use it for any
> purpose other than intended, or copy, distribute or store the information
on any medium.
> Copyright in this e-mail and attachments created by us belong to ECB and
the author also
> asserts the right to be identified as such and to prevent any misuse.
Please conduct your
> own virus checks.  The ECB does not accept responsibility or liability for
any virus or any
> loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.
>
>
>
>

Hello,

Well what I was pointing at in my e-mail is that I have not yet written the
ASP program. What I am trying to decide is whether I should put out the
effort now to write the program or just make it simple by just giving them
access to the up-to-date database from access or word, since they are
already used to using these applications already. Is this clear?

Neile

-----Original Message-----
From: Anand [mailto:info@s...] 
Sent: 06 February 2003 08:18
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through
Intranet


HI,

If you are using asp application then why do you want your users to learn
the SQL or Access database? When you make asp program to do all jobs like
printing address's and else things then your users should know how to
operate your asp program not sql or any others database. I hope this would
make clear to you if not do write more about your application.

Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar,  Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Neile Bermudes" <Neile.Bermudes@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, February 05, 2003 11:54 AM
Subject: [asp_databases] Ability to print address labels through Intranet


> Hello,
>
> I have been asked to create a system that will allow staff to print
address
> labels for different groups of people through the Intranet. At the 
> moment, as it is a small company, staff create their own address 
> tables/databases
in
> either access or word- but this means that everyone has their own 
> source
of
> information and it is usually out of date. I have now moved our whole 
> employee database that was in Access into SQL, and would like all 
> staff to use this one source of information. Ultimately, the request 
> has been that staff should be able to, through the intranet, create ad 
> hoc groups of addresses and print these onto labels for mailouts. 
> However, I know this means me writing some sort of ASP/SQL based 
> program- and due to my restrictive time line, I wouldn't mind looking 
> at other ways. However, if the application is the only way, I'll do 
> it.
>
> Originally, my idea was to create a linked table in Access (that links 
> to the SQL employee database and therefore stays up-to-date) and give
everyone
> access to this source. The good thing here is that people can stay in
Access
> without having to learn something new, the address info is always up 
> to
date
> and especially, is not hard for me to set up. The downfall is that, 
> one, I would have to create the linked table on each persons machine 
> and two, I don't know if Access can handle this especially over a 
> network connection, and potentially over long distances if our remote 
> sites are to use this database.
>
> Does anyone have any suggestions, whatever they be I would be 
> interested
to
> here them. It would be especially helpful if someone has actually 
> created
a
> system like this before or is using one at the moment. If the 
> suggestion
is
> that I do write the ASP system, please pass it on as well.
>
> Thanks a lot
> Neile
>
> --
>
> Neile Bermudes
> Network Support Analyst
> ECB IT Dept
> 020 74321241
>
>
>
> The contents of this e-mail are the property of the ECB.  This e-mail 
> (and
any attachments)
> are confidential and intended for use by the named recipient(s) only.  
> It
may contain
> confidential or privileged information.  Any opinions expressed herein 
> are
those of the
> individual and not necessarily those of the ECB. If you are not the
intended recipient would
> you please immediately delete this e-mail and any attachments from 
> your
computer system
> without publishing, copying or distributing it, and notify the sender 
> at
the ECB.  Do not
> disclose this e-mail or the information disclosed herein to any other
person, use it for any
> purpose other than intended, or copy, distribute or store the 
> information
on any medium.
> Copyright in this e-mail and attachments created by us belong to ECB 
> and
the author also
> asserts the right to be identified as such and to prevent any misuse.
Please conduct your
> own virus checks.  The ECB does not accept responsibility or liability 
> for
any virus or any
> loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.
>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to 
> unsubscribe send a blank email to
>




The contents of this e-mail are the property of the ECB.  This e-mail (and any attachments) 
are confidential and intended for use by the named recipient(s) only.  It may contain 
confidential or privileged information.  Any opinions expressed herein are those of the 
individual and not necessarily those of the ECB. If you are not the intended recipient would 
you please immediately delete this e-mail and any attachments from your computer system 
without publishing, copying or distributing it, and notify the sender at the ECB.  Do not 
disclose this e-mail or the information disclosed herein to any other person, use it for any 
purpose other than intended, or copy, distribute or store the information on any medium. 
Copyright in this e-mail and attachments created by us belong to ECB and the author also 
asserts the right to be identified as such and to prevent any misuse.  Please conduct your 
own virus checks.  The ECB does not accept responsibility or liability for any virus or any 
loss or damage caused by such software virus.  Our web site is at http://www.ecb.co.uk.

Neile,

I had to create a label printing system not so long back, although it was
for a proper barcode label printer, rather than printing from Word/Excel.

Although not the same application, it's fairly similar. I wrote a quick and
easy VB program with the Internet Control and had this application access
our Intranet. All pages are designed as normal, but taking into mind the
smaller screen size of my application.

The pages I made on the intranet allowed users to request parts of the
address file depending on their needs. The page that would show the results
was coded to dump the data onto the page as a CSV format. Nothing actually
appeared on the screen as my application would take the raw data and place
it into a listview. My application in VB then detected whenever the page
(results.asp) was called, waited for the download to complete and then took
the content from the page and put it into a Listview in my VB program for
the user to see. Once they were happy, they hit print.

It was easy to use, and surprisingly easy to create in VB. The Internet
control does all the work and provides all the events you need. All I had to
do was to create the pages for the Intranet and I was done!

As I said, probably not 100% what you are after, but I needed a polished
program which took away any hassle from users and I thought you might want
some ideas.


Craig.




-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 09:47
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Hello,

Well what I was pointing at in my e-mail is that I have not yet written the
ASP program. What I am trying to decide is whether I should put out the
effort now to write the program or just make it simple by just giving them
access to the up-to-date database from access or word, since they are
already used to using these applications already. Is this clear?

Neile

-----Original Message-----
From: Anand [mailto:info@s...]
Sent: 06 February 2003 08:18
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through
Intranet


HI,

If you are using asp application then why do you want your users to learn
the SQL or Access database? When you make asp program to do all jobs like
printing address's and else things then your users should know how to
operate your asp program not sql or any others database. I hope this would
make clear to you if not do write more about your application.

Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar,  Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Neile Bermudes" <Neile.Bermudes@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, February 05, 2003 11:54 AM
Subject: [asp_databases] Ability to print address labels through Intranet


> Hello,
>
> I have been asked to create a system that will allow staff to print
address
> labels for different groups of people through the Intranet. At the
> moment, as it is a small company, staff create their own address
> tables/databases
in
> either access or word- but this means that everyone has their own
> source
of
> information and it is usually out of date. I have now moved our whole
> employee database that was in Access into SQL, and would like all
> staff to use this one source of information. Ultimately, the request
> has been that staff should be able to, through the intranet, create ad
> hoc groups of addresses and print these onto labels for mailouts.
> However, I know this means me writing some sort of ASP/SQL based
> program- and due to my restrictive time line, I wouldn't mind looking
> at other ways. However, if the application is the only way, I'll do
> it.
>
> Originally, my idea was to create a linked table in Access (that links
> to the SQL employee database and therefore stays up-to-date) and give
everyone
> access to this source. The good thing here is that people can stay in
Access
> without having to learn something new, the address info is always up
> to
date
> and especially, is not hard for me to set up. The downfall is that,
> one, I would have to create the linked table on each persons machine
> and two, I don't know if Access can handle this especially over a
> network connection, and potentially over long distances if our remote
> sites are to use this database.
>
> Does anyone have any suggestions, whatever they be I would be
> interested
to
> here them. It would be especially helpful if someone has actually
> created
a
> system like this before or is using one at the moment. If the
> suggestion
is
> that I do write the ASP system, please pass it on as well.
>
> Thanks a lot
> Neile
>
> --
>
> Neile Bermudes
> Network Support Analyst
> ECB IT Dept
> 020 74321241
>
>
>
> The contents of this e-mail are the property of the ECB.  This e-mail
> (and
any attachments)
> are confidential and intended for use by the named recipient(s) only.
> It
may contain
> confidential or privileged information.  Any opinions expressed herein
> are
those of the
> individual and not necessarily those of the ECB. If you are not the
intended recipient would
> you please immediately delete this e-mail and any attachments from
> your
computer system
> without publishing, copying or distributing it, and notify the sender
> at
the ECB.  Do not
> disclose this e-mail or the information disclosed herein to any other
person, use it for any
> purpose other than intended, or copy, distribute or store the
> information
on any medium.
> Copyright in this e-mail and attachments created by us belong to ECB
> and
the author also
> asserts the right to be identified as such and to prevent any misuse.
Please conduct your
> own virus checks.  The ECB does not accept responsibility or liability
> for
any virus or any
> loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.
>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>




The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments)
are confidential and intended for use by the named recipient(s) only.  It
may contain
confidential or privileged information.  Any opinions expressed herein are
those of the
individual and not necessarily those of the ECB. If you are not the intended
recipient would
you please immediately delete this e-mail and any attachments from your
computer system
without publishing, copying or distributing it, and notify the sender at the
ECB.  Do not
disclose this e-mail or the information disclosed herein to any other
person, use it for any
purpose other than intended, or copy, distribute or store the information on
any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also
asserts the right to be identified as such and to prevent any misuse.
Please conduct your
own virus checks.  The ECB does not accept responsibility or liability for
any virus or any
loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.



_____________________________________________________________________
Please contact I.T. Support if you have received this email in error.
This e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

Craig,

Thank you for getting back to me- much appreciated.

I hadn't contemplated using VB, I don't know the language. But at this
point, I'm open to anything even if this just gives me an idea of how to
approach the project.

Cheers

Neile

-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...] 
Sent: 10 February 2003 09:56
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Neile,

I had to create a label printing system not so long back, although it was
for a proper barcode label printer, rather than printing from Word/Excel.

Although not the same application, it's fairly similar. I wrote a quick and
easy VB program with the Internet Control and had this application access
our Intranet. All pages are designed as normal, but taking into mind the
smaller screen size of my application.

The pages I made on the intranet allowed users to request parts of the
address file depending on their needs. The page that would show the results
was coded to dump the data onto the page as a CSV format. Nothing actually
appeared on the screen as my application would take the raw data and place
it into a listview. My application in VB then detected whenever the page
(results.asp) was called, waited for the download to complete and then took
the content from the page and put it into a Listview in my VB program for
the user to see. Once they were happy, they hit print.

It was easy to use, and surprisingly easy to create in VB. The Internet
control does all the work and provides all the events you need. All I had to
do was to create the pages for the Intranet and I was done!

As I said, probably not 100% what you are after, but I needed a polished
program which took away any hassle from users and I thought you might want
some ideas.


Craig.




-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 09:47
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Hello,

Well what I was pointing at in my e-mail is that I have not yet written the
ASP program. What I am trying to decide is whether I should put out the
effort now to write the program or just make it simple by just giving them
access to the up-to-date database from access or word, since they are
already used to using these applications already. Is this clear?

Neile

-----Original Message-----
From: Anand [mailto:info@s...]
Sent: 06 February 2003 08:18
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through
Intranet


HI,

If you are using asp application then why do you want your users to learn
the SQL or Access database? When you make asp program to do all jobs like
printing address's and else things then your users should know how to
operate your asp program not sql or any others database. I hope this would
make clear to you if not do write more about your application.

Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar,  Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Neile Bermudes" <Neile.Bermudes@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, February 05, 2003 11:54 AM
Subject: [asp_databases] Ability to print address labels through Intranet


> Hello,
>
> I have been asked to create a system that will allow staff to print
address
> labels for different groups of people through the Intranet. At the 
> moment, as it is a small company, staff create their own address 
> tables/databases
in
> either access or word- but this means that everyone has their own 
> source
of
> information and it is usually out of date. I have now moved our whole 
> employee database that was in Access into SQL, and would like all 
> staff to use this one source of information. Ultimately, the request 
> has been that staff should be able to, through the intranet, create ad 
> hoc groups of addresses and print these onto labels for mailouts. 
> However, I know this means me writing some sort of ASP/SQL based
> program- and due to my restrictive time line, I wouldn't mind looking 
> at other ways. However, if the application is the only way, I'll do 
> it.
>
> Originally, my idea was to create a linked table in Access (that links 
> to the SQL employee database and therefore stays up-to-date) and give
everyone
> access to this source. The good thing here is that people can stay in
Access
> without having to learn something new, the address info is always up 
> to
date
> and especially, is not hard for me to set up. The downfall is that, 
> one, I would have to create the linked table on each persons machine 
> and two, I don't know if Access can handle this especially over a 
> network connection, and potentially over long distances if our remote 
> sites are to use this database.
>
> Does anyone have any suggestions, whatever they be I would be 
> interested
to
> here them. It would be especially helpful if someone has actually 
> created
a
> system like this before or is using one at the moment. If the 
> suggestion
is
> that I do write the ASP system, please pass it on as well.
>
> Thanks a lot
> Neile
>
> --
>
> Neile Bermudes
> Network Support Analyst
> ECB IT Dept
> 020 74321241
>
>
>
> The contents of this e-mail are the property of the ECB.  This e-mail 
> (and
any attachments)
> are confidential and intended for use by the named recipient(s) only. 
> It
may contain
> confidential or privileged information.  Any opinions expressed herein 
> are
those of the
> individual and not necessarily those of the ECB. If you are not the
intended recipient would
> you please immediately delete this e-mail and any attachments from 
> your
computer system
> without publishing, copying or distributing it, and notify the sender 
> at
the ECB.  Do not
> disclose this e-mail or the information disclosed herein to any other
person, use it for any
> purpose other than intended, or copy, distribute or store the 
> information
on any medium.
> Copyright in this e-mail and attachments created by us belong to ECB 
> and
the author also
> asserts the right to be identified as such and to prevent any misuse.
Please conduct your
> own virus checks.  The ECB does not accept responsibility or liability 
> for
any virus or any
> loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.
>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to 
> unsubscribe send a blank email to
>


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments) are confidential and intended for use by the named
recipient(s) only.  It may contain confidential or privileged information.
Any opinions expressed herein are those of the individual and not
necessarily those of the ECB. If you are not the intended recipient would
you please immediately delete this e-mail and any attachments from your
computer system without publishing, copying or distributing it, and notify
the sender at the ECB.  Do not disclose this e-mail or the information
disclosed herein to any other person, use it for any purpose other than
intended, or copy, distribute or store the information on any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also asserts the right to be identified as such and to prevent any
misuse. Please conduct your own virus checks.  The ECB does not accept
responsibility or liability for any virus or any loss or damage caused by
such software virus.  Our web site is at http://www.ecb.co.uk.


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error. This
e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in error
you must take no action based on them, nor must you copy or show them to
anyone; please reply to this email and highlight the error.

Security Warning : Please note that this email has been created in the
knowledge that the internet is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when emailing
us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with good
computing practice, the recipient should ensure they are actually virus
free. _____________________________________________________________________



The contents of this e-mail are the property of the ECB.  This e-mail (and any attachments) 
are confidential and intended for use by the named recipient(s) only.  It may contain 
confidential or privileged information.  Any opinions expressed herein are those of the 
individual and not necessarily those of the ECB. If you are not the intended recipient would 
you please immediately delete this e-mail and any attachments from your computer system 
without publishing, copying or distributing it, and notify the sender at the ECB.  Do not 
disclose this e-mail or the information disclosed herein to any other person, use it for any 
purpose other than intended, or copy, distribute or store the information on any medium. 
Copyright in this e-mail and attachments created by us belong to ECB and the author also 
asserts the right to be identified as such and to prevent any misuse.  Please conduct your 
own virus checks.  The ECB does not accept responsibility or liability for any virus or any 
loss or damage caused by such software virus.  Our web site is at http://www.ecb.co.uk.

Hi,

If your users are comfortable at using Mail Merge facilities, you could get
the Intranet to create a dataset of addresses depending on their selections,
have it downloaded as a file (CSV) to their PC and then they use a standard
Mail-Merge template through a Label design in Word.

That might work.

Cheers
Craig.


-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 10:12
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Craig,

Thank you for getting back to me- much appreciated.

I hadn't contemplated using VB, I don't know the language. But at this
point, I'm open to anything even if this just gives me an idea of how to
approach the project.

Cheers

Neile

-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: 10 February 2003 09:56
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Neile,

I had to create a label printing system not so long back, although it was
for a proper barcode label printer, rather than printing from Word/Excel.

Although not the same application, it's fairly similar. I wrote a quick and
easy VB program with the Internet Control and had this application access
our Intranet. All pages are designed as normal, but taking into mind the
smaller screen size of my application.

The pages I made on the intranet allowed users to request parts of the
address file depending on their needs. The page that would show the results
was coded to dump the data onto the page as a CSV format. Nothing actually
appeared on the screen as my application would take the raw data and place
it into a listview. My application in VB then detected whenever the page
(results.asp) was called, waited for the download to complete and then took
the content from the page and put it into a Listview in my VB program for
the user to see. Once they were happy, they hit print.

It was easy to use, and surprisingly easy to create in VB. The Internet
control does all the work and provides all the events you need. All I had to
do was to create the pages for the Intranet and I was done!

As I said, probably not 100% what you are after, but I needed a polished
program which took away any hassle from users and I thought you might want
some ideas.


Craig.




-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 09:47
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Hello,

Well what I was pointing at in my e-mail is that I have not yet written the
ASP program. What I am trying to decide is whether I should put out the
effort now to write the program or just make it simple by just giving them
access to the up-to-date database from access or word, since they are
already used to using these applications already. Is this clear?

Neile

-----Original Message-----
From: Anand [mailto:info@s...]
Sent: 06 February 2003 08:18
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through
Intranet


HI,

If you are using asp application then why do you want your users to learn
the SQL or Access database? When you make asp program to do all jobs like
printing address's and else things then your users should know how to
operate your asp program not sql or any others database. I hope this would
make clear to you if not do write more about your application.

Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar,  Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Neile Bermudes" <Neile.Bermudes@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, February 05, 2003 11:54 AM
Subject: [asp_databases] Ability to print address labels through Intranet


> Hello,
>
> I have been asked to create a system that will allow staff to print
address
> labels for different groups of people through the Intranet. At the
> moment, as it is a small company, staff create their own address
> tables/databases
in
> either access or word- but this means that everyone has their own
> source
of
> information and it is usually out of date. I have now moved our whole
> employee database that was in Access into SQL, and would like all
> staff to use this one source of information. Ultimately, the request
> has been that staff should be able to, through the intranet, create ad
> hoc groups of addresses and print these onto labels for mailouts.
> However, I know this means me writing some sort of ASP/SQL based
> program- and due to my restrictive time line, I wouldn't mind looking
> at other ways. However, if the application is the only way, I'll do
> it.
>
> Originally, my idea was to create a linked table in Access (that links
> to the SQL employee database and therefore stays up-to-date) and give
everyone
> access to this source. The good thing here is that people can stay in
Access
> without having to learn something new, the address info is always up
> to
date
> and especially, is not hard for me to set up. The downfall is that,
> one, I would have to create the linked table on each persons machine
> and two, I don't know if Access can handle this especially over a
> network connection, and potentially over long distances if our remote
> sites are to use this database.
>
> Does anyone have any suggestions, whatever they be I would be
> interested
to
> here them. It would be especially helpful if someone has actually
> created
a
> system like this before or is using one at the moment. If the
> suggestion
is
> that I do write the ASP system, please pass it on as well.
>
> Thanks a lot
> Neile
>
> --
>
> Neile Bermudes
> Network Support Analyst
> ECB IT Dept
> 020 74321241
>
>
>
> The contents of this e-mail are the property of the ECB.  This e-mail
> (and
any attachments)
> are confidential and intended for use by the named recipient(s) only.
> It
may contain
> confidential or privileged information.  Any opinions expressed herein
> are
those of the
> individual and not necessarily those of the ECB. If you are not the
intended recipient would
> you please immediately delete this e-mail and any attachments from
> your
computer system
> without publishing, copying or distributing it, and notify the sender
> at
the ECB.  Do not
> disclose this e-mail or the information disclosed herein to any other
person, use it for any
> purpose other than intended, or copy, distribute or store the
> information
on any medium.
> Copyright in this e-mail and attachments created by us belong to ECB
> and
the author also
> asserts the right to be identified as such and to prevent any misuse.
Please conduct your
> own virus checks.  The ECB does not accept responsibility or liability
> for
any virus or any
> loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.
>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments) are confidential and intended for use by the named
recipient(s) only.  It may contain confidential or privileged information.
Any opinions expressed herein are those of the individual and not
necessarily those of the ECB. If you are not the intended recipient would
you please immediately delete this e-mail and any attachments from your
computer system without publishing, copying or distributing it, and notify
the sender at the ECB.  Do not disclose this e-mail or the information
disclosed herein to any other person, use it for any purpose other than
intended, or copy, distribute or store the information on any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also asserts the right to be identified as such and to prevent any
misuse. Please conduct your own virus checks.  The ECB does not accept
responsibility or liability for any virus or any loss or damage caused by
such software virus.  Our web site is at http://www.ecb.co.uk.


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error. This
e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in error
you must take no action based on them, nor must you copy or show them to
anyone; please reply to this email and highlight the error.

Security Warning : Please note that this email has been created in the
knowledge that the internet is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when emailing
us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with good
computing practice, the recipient should ensure they are actually virus
free. _____________________________________________________________________



The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments)
are confidential and intended for use by the named recipient(s) only.  It
may contain
confidential or privileged information.  Any opinions expressed herein are
those of the
individual and not necessarily those of the ECB. If you are not the intended
recipient would
you please immediately delete this e-mail and any attachments from your
computer system
without publishing, copying or distributing it, and notify the sender at the
ECB.  Do not
disclose this e-mail or the information disclosed herein to any other
person, use it for any
purpose other than intended, or copy, distribute or store the information on
any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also
asserts the right to be identified as such and to prevent any misuse.
Please conduct your
own virus checks.  The ECB does not accept responsibility or liability for
any virus or any
loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.



_____________________________________________________________________
Please contact I.T. Support if you have received this email in error.
This e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

You mean using VB or ASP?

-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...] 
Sent: 10 February 2003 10:43
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Hi,

If your users are comfortable at using Mail Merge facilities, you could get
the Intranet to create a dataset of addresses depending on their selections,
have it downloaded as a file (CSV) to their PC and then they use a standard
Mail-Merge template through a Label design in Word.

That might work.

Cheers
Craig.


-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 10:12
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Craig,

Thank you for getting back to me- much appreciated.

I hadn't contemplated using VB, I don't know the language. But at this
point, I'm open to anything even if this just gives me an idea of how to
approach the project.

Cheers

Neile

-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: 10 February 2003 09:56
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Neile,

I had to create a label printing system not so long back, although it was
for a proper barcode label printer, rather than printing from Word/Excel.

Although not the same application, it's fairly similar. I wrote a quick and
easy VB program with the Internet Control and had this application access
our Intranet. All pages are designed as normal, but taking into mind the
smaller screen size of my application.

The pages I made on the intranet allowed users to request parts of the
address file depending on their needs. The page that would show the results
was coded to dump the data onto the page as a CSV format. Nothing actually
appeared on the screen as my application would take the raw data and place
it into a listview. My application in VB then detected whenever the page
(results.asp) was called, waited for the download to complete and then took
the content from the page and put it into a Listview in my VB program for
the user to see. Once they were happy, they hit print.

It was easy to use, and surprisingly easy to create in VB. The Internet
control does all the work and provides all the events you need. All I had to
do was to create the pages for the Intranet and I was done!

As I said, probably not 100% what you are after, but I needed a polished
program which took away any hassle from users and I thought you might want
some ideas.


Craig.




-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 09:47
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Hello,

Well what I was pointing at in my e-mail is that I have not yet written the
ASP program. What I am trying to decide is whether I should put out the
effort now to write the program or just make it simple by just giving them
access to the up-to-date database from access or word, since they are
already used to using these applications already. Is this clear?

Neile

-----Original Message-----
From: Anand [mailto:info@s...]
Sent: 06 February 2003 08:18
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through
Intranet


HI,

If you are using asp application then why do you want your users to learn
the SQL or Access database? When you make asp program to do all jobs like
printing address's and else things then your users should know how to
operate your asp program not sql or any others database. I hope this would
make clear to you if not do write more about your application.

Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar,  Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Neile Bermudes" <Neile.Bermudes@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, February 05, 2003 11:54 AM
Subject: [asp_databases] Ability to print address labels through Intranet


> Hello,
>
> I have been asked to create a system that will allow staff to print
address
> labels for different groups of people through the Intranet. At the 
> moment, as it is a small company, staff create their own address 
> tables/databases
in
> either access or word- but this means that everyone has their own 
> source
of
> information and it is usually out of date. I have now moved our whole 
> employee database that was in Access into SQL, and would like all 
> staff to use this one source of information. Ultimately, the request 
> has been that staff should be able to, through the intranet, create ad 
> hoc groups of addresses and print these onto labels for mailouts. 
> However, I know this means me writing some sort of ASP/SQL based
> program- and due to my restrictive time line, I wouldn't mind looking 
> at other ways. However, if the application is the only way, I'll do 
> it.
>
> Originally, my idea was to create a linked table in Access (that links 
> to the SQL employee database and therefore stays up-to-date) and give
everyone
> access to this source. The good thing here is that people can stay in
Access
> without having to learn something new, the address info is always up 
> to
date
> and especially, is not hard for me to set up. The downfall is that, 
> one, I would have to create the linked table on each persons machine 
> and two, I don't know if Access can handle this especially over a 
> network connection, and potentially over long distances if our remote 
> sites are to use this database.
>
> Does anyone have any suggestions, whatever they be I would be 
> interested
to
> here them. It would be especially helpful if someone has actually 
> created
a
> system like this before or is using one at the moment. If the 
> suggestion
is
> that I do write the ASP system, please pass it on as well.
>
> Thanks a lot
> Neile
>
> --
>
> Neile Bermudes
> Network Support Analyst
> ECB IT Dept
> 020 74321241
>
>
>
> The contents of this e-mail are the property of the ECB.  This e-mail 
> (and
any attachments)
> are confidential and intended for use by the named recipient(s) only. 
> It
may contain
> confidential or privileged information.  Any opinions expressed herein 
> are
those of the
> individual and not necessarily those of the ECB. If you are not the
intended recipient would
> you please immediately delete this e-mail and any attachments from 
> your
computer system
> without publishing, copying or distributing it, and notify the sender 
> at
the ECB.  Do not
> disclose this e-mail or the information disclosed herein to any other
person, use it for any
> purpose other than intended, or copy, distribute or store the 
> information
on any medium.
> Copyright in this e-mail and attachments created by us belong to ECB 
> and
the author also
> asserts the right to be identified as such and to prevent any misuse.
Please conduct your
> own virus checks.  The ECB does not accept responsibility or liability 
> for
any virus or any
> loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.
>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to 
> unsubscribe send a blank email to
>


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments) are confidential and intended for use by the named
recipient(s) only.  It may contain confidential or privileged information.
Any opinions expressed herein are those of the individual and not
necessarily those of the ECB. If you are not the intended recipient would
you please immediately delete this e-mail and any attachments from your
computer system without publishing, copying or distributing it, and notify
the sender at the ECB.  Do not disclose this e-mail or the information
disclosed herein to any other person, use it for any purpose other than
intended, or copy, distribute or store the information on any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also asserts the right to be identified as such and to prevent any
misuse. Please conduct your own virus checks.  The ECB does not accept
responsibility or liability for any virus or any loss or damage caused by
such software virus.  Our web site is at http://www.ecb.co.uk.


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error. This
e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in error
you must take no action based on them, nor must you copy or show them to
anyone; please reply to this email and highlight the error.

Security Warning : Please note that this email has been created in the
knowledge that the internet is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when emailing
us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with good
computing practice, the recipient should ensure they are actually virus
free. _____________________________________________________________________

---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments) are confidential and intended for use by the named
recipient(s) only.  It may contain confidential or privileged information.
Any opinions expressed herein are those of the individual and not
necessarily those of the ECB. If you are not the intended recipient would
you please immediately delete this e-mail and any attachments from your
computer system without publishing, copying or distributing it, and notify
the sender at the ECB.  Do not disclose this e-mail or the information
disclosed herein to any other person, use it for any purpose other than
intended, or copy, distribute or store the information on any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also asserts the right to be identified as such and to prevent any
misuse. Please conduct your own virus checks.  The ECB does not accept
responsibility or liability for any virus or any loss or damage caused by
such software virus.  Our web site is at http://www.ecb.co.uk.


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error. This
e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in error
you must take no action based on them, nor must you copy or show them to
anyone; please reply to this email and highlight the error.

Security Warning : Please note that this email has been created in the
knowledge that the internet is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when emailing
us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with good
computing practice, the recipient should ensure they are actually virus
free. _____________________________________________________________________



The contents of this e-mail are the property of the ECB.  This e-mail (and any attachments) 
are confidential and intended for use by the named recipient(s) only.  It may contain 
confidential or privileged information.  Any opinions expressed herein are those of the 
individual and not necessarily those of the ECB. If you are not the intended recipient would 
you please immediately delete this e-mail and any attachments from your computer system 
without publishing, copying or distributing it, and notify the sender at the ECB.  Do not 
disclose this e-mail or the information disclosed herein to any other person, use it for any 
purpose other than intended, or copy, distribute or store the information on any medium. 
Copyright in this e-mail and attachments created by us belong to ECB and the author also 
asserts the right to be identified as such and to prevent any misuse.  Please conduct your 
own virus checks.  The ECB does not accept responsibility or liability for any virus or any 
loss or damage caused by such software virus.  Our web site is at http://www.ecb.co.uk.

Create a system with ASP that lets users create a dataset - then they
download this to their PC.
You can then create a Mail-Merge file in a Label style for them. They then
open up this template, specify a data source (their downloaded file) and
they are away!

It's all theoretical - I've not tried it myself.

This way, you're avoiding VB.

One other suggestion - try going to Avery's website. They used to have
software that was free where you could create labels either standalone, or
through Word. It might have a data import facility?





-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 11:02
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


You mean using VB or ASP?

-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: 10 February 2003 10:43
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Hi,

If your users are comfortable at using Mail Merge facilities, you could get
the Intranet to create a dataset of addresses depending on their selections,
have it downloaded as a file (CSV) to their PC and then they use a standard
Mail-Merge template through a Label design in Word.

That might work.

Cheers
Craig.


-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 10:12
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Craig,

Thank you for getting back to me- much appreciated.

I hadn't contemplated using VB, I don't know the language. But at this
point, I'm open to anything even if this just gives me an idea of how to
approach the project.

Cheers

Neile

-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: 10 February 2003 09:56
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Neile,

I had to create a label printing system not so long back, although it was
for a proper barcode label printer, rather than printing from Word/Excel.

Although not the same application, it's fairly similar. I wrote a quick and
easy VB program with the Internet Control and had this application access
our Intranet. All pages are designed as normal, but taking into mind the
smaller screen size of my application.

The pages I made on the intranet allowed users to request parts of the
address file depending on their needs. The page that would show the results
was coded to dump the data onto the page as a CSV format. Nothing actually
appeared on the screen as my application would take the raw data and place
it into a listview. My application in VB then detected whenever the page
(results.asp) was called, waited for the download to complete and then took
the content from the page and put it into a Listview in my VB program for
the user to see. Once they were happy, they hit print.

It was easy to use, and surprisingly easy to create in VB. The Internet
control does all the work and provides all the events you need. All I had to
do was to create the pages for the Intranet and I was done!

As I said, probably not 100% what you are after, but I needed a polished
program which took away any hassle from users and I thought you might want
some ideas.


Craig.




-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 09:47
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Hello,

Well what I was pointing at in my e-mail is that I have not yet written the
ASP program. What I am trying to decide is whether I should put out the
effort now to write the program or just make it simple by just giving them
access to the up-to-date database from access or word, since they are
already used to using these applications already. Is this clear?

Neile

-----Original Message-----
From: Anand [mailto:info@s...]
Sent: 06 February 2003 08:18
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through
Intranet


HI,

If you are using asp application then why do you want your users to learn
the SQL or Access database? When you make asp program to do all jobs like
printing address's and else things then your users should know how to
operate your asp program not sql or any others database. I hope this would
make clear to you if not do write more about your application.

Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar,  Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Neile Bermudes" <Neile.Bermudes@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, February 05, 2003 11:54 AM
Subject: [asp_databases] Ability to print address labels through Intranet


> Hello,
>
> I have been asked to create a system that will allow staff to print
address
> labels for different groups of people through the Intranet. At the
> moment, as it is a small company, staff create their own address
> tables/databases
in
> either access or word- but this means that everyone has their own
> source
of
> information and it is usually out of date. I have now moved our whole
> employee database that was in Access into SQL, and would like all
> staff to use this one source of information. Ultimately, the request
> has been that staff should be able to, through the intranet, create ad
> hoc groups of addresses and print these onto labels for mailouts.
> However, I know this means me writing some sort of ASP/SQL based
> program- and due to my restrictive time line, I wouldn't mind looking
> at other ways. However, if the application is the only way, I'll do
> it.
>
> Originally, my idea was to create a linked table in Access (that links
> to the SQL employee database and therefore stays up-to-date) and give
everyone
> access to this source. The good thing here is that people can stay in
Access
> without having to learn something new, the address info is always up
> to
date
> and especially, is not hard for me to set up. The downfall is that,
> one, I would have to create the linked table on each persons machine
> and two, I don't know if Access can handle this especially over a
> network connection, and potentially over long distances if our remote
> sites are to use this database.
>
> Does anyone have any suggestions, whatever they be I would be
> interested
to
> here them. It would be especially helpful if someone has actually
> created
a
> system like this before or is using one at the moment. If the
> suggestion
is
> that I do write the ASP system, please pass it on as well.
>
> Thanks a lot
> Neile
>
> --
>
> Neile Bermudes
> Network Support Analyst
> ECB IT Dept
> 020 74321241
>
>
>
> The contents of this e-mail are the property of the ECB.  This e-mail
> (and
any attachments)
> are confidential and intended for use by the named recipient(s) only.
> It
may contain
> confidential or privileged information.  Any opinions expressed herein
> are
those of the
> individual and not necessarily those of the ECB. If you are not the
intended recipient would
> you please immediately delete this e-mail and any attachments from
> your
computer system
> without publishing, copying or distributing it, and notify the sender
> at
the ECB.  Do not
> disclose this e-mail or the information disclosed herein to any other
person, use it for any
> purpose other than intended, or copy, distribute or store the
> information
on any medium.
> Copyright in this e-mail and attachments created by us belong to ECB
> and
the author also
> asserts the right to be identified as such and to prevent any misuse.
Please conduct your
> own virus checks.  The ECB does not accept responsibility or liability
> for
any virus or any
> loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.
>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments) are confidential and intended for use by the named
recipient(s) only.  It may contain confidential or privileged information.
Any opinions expressed herein are those of the individual and not
necessarily those of the ECB. If you are not the intended recipient would
you please immediately delete this e-mail and any attachments from your
computer system without publishing, copying or distributing it, and notify
the sender at the ECB.  Do not disclose this e-mail or the information
disclosed herein to any other person, use it for any purpose other than
intended, or copy, distribute or store the information on any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also asserts the right to be identified as such and to prevent any
misuse. Please conduct your own virus checks.  The ECB does not accept
responsibility or liability for any virus or any loss or damage caused by
such software virus.  Our web site is at http://www.ecb.co.uk.


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error. This
e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in error
you must take no action based on them, nor must you copy or show them to
anyone; please reply to this email and highlight the error.

Security Warning : Please note that this email has been created in the
knowledge that the internet is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when emailing
us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with good
computing practice, the recipient should ensure they are actually virus
free. _____________________________________________________________________

---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments) are confidential and intended for use by the named
recipient(s) only.  It may contain confidential or privileged information.
Any opinions expressed herein are those of the individual and not
necessarily those of the ECB. If you are not the intended recipient would
you please immediately delete this e-mail and any attachments from your
computer system without publishing, copying or distributing it, and notify
the sender at the ECB.  Do not disclose this e-mail or the information
disclosed herein to any other person, use it for any purpose other than
intended, or copy, distribute or store the information on any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also asserts the right to be identified as such and to prevent any
misuse. Please conduct your own virus checks.  The ECB does not accept
responsibility or liability for any virus or any loss or damage caused by
such software virus.  Our web site is at http://www.ecb.co.uk.


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error. This
e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in error
you must take no action based on them, nor must you copy or show them to
anyone; please reply to this email and highlight the error.

Security Warning : Please note that this email has been created in the
knowledge that the internet is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when emailing
us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with good
computing practice, the recipient should ensure they are actually virus
free. _____________________________________________________________________



The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments)
are confidential and intended for use by the named recipient(s) only.  It
may contain
confidential or privileged information.  Any opinions expressed herein are
those of the
individual and not necessarily those of the ECB. If you are not the intended
recipient would
you please immediately delete this e-mail and any attachments from your
computer system
without publishing, copying or distributing it, and notify the sender at the
ECB.  Do not
disclose this e-mail or the information disclosed herein to any other
person, use it for any
purpose other than intended, or copy, distribute or store the information on
any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also
asserts the right to be identified as such and to prevent any misuse.
Please conduct your
own virus checks.  The ECB does not accept responsibility or liability for
any virus or any
loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.



_____________________________________________________________________
Please contact I.T. Support if you have received this email in error.
This e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

Thanks a lot Craig- yes, the hope is not to have to learn a new language.
I'll have a look at the Avery website as well.
Cheers, Neile

-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...] 
Sent: 10 February 2003 11:02
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Create a system with ASP that lets users create a dataset - then they
download this to their PC. You can then create a Mail-Merge file in a Label
style for them. They then open up this template, specify a data source
(their downloaded file) and they are away!

It's all theoretical - I've not tried it myself.

This way, you're avoiding VB.

One other suggestion - try going to Avery's website. They used to have
software that was free where you could create labels either standalone, or
through Word. It might have a data import facility?





-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 11:02
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


You mean using VB or ASP?

-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: 10 February 2003 10:43
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Hi,

If your users are comfortable at using Mail Merge facilities, you could get
the Intranet to create a dataset of addresses depending on their selections,
have it downloaded as a file (CSV) to their PC and then they use a standard
Mail-Merge template through a Label design in Word.

That might work.

Cheers
Craig.


-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 10:12
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Craig,

Thank you for getting back to me- much appreciated.

I hadn't contemplated using VB, I don't know the language. But at this
point, I'm open to anything even if this just gives me an idea of how to
approach the project.

Cheers

Neile

-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: 10 February 2003 09:56
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Neile,

I had to create a label printing system not so long back, although it was
for a proper barcode label printer, rather than printing from Word/Excel.

Although not the same application, it's fairly similar. I wrote a quick and
easy VB program with the Internet Control and had this application access
our Intranet. All pages are designed as normal, but taking into mind the
smaller screen size of my application.

The pages I made on the intranet allowed users to request parts of the
address file depending on their needs. The page that would show the results
was coded to dump the data onto the page as a CSV format. Nothing actually
appeared on the screen as my application would take the raw data and place
it into a listview. My application in VB then detected whenever the page
(results.asp) was called, waited for the download to complete and then took
the content from the page and put it into a Listview in my VB program for
the user to see. Once they were happy, they hit print.

It was easy to use, and surprisingly easy to create in VB. The Internet
control does all the work and provides all the events you need. All I had to
do was to create the pages for the Intranet and I was done!

As I said, probably not 100% what you are after, but I needed a polished
program which took away any hassle from users and I thought you might want
some ideas.


Craig.




-----Original Message-----
From: Neile Bermudes [mailto:Neile.Bermudes@e...]
Sent: 10 February 2003 09:47
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through I
ntranet


Hello,

Well what I was pointing at in my e-mail is that I have not yet written the
ASP program. What I am trying to decide is whether I should put out the
effort now to write the program or just make it simple by just giving them
access to the up-to-date database from access or word, since they are
already used to using these applications already. Is this clear?

Neile

-----Original Message-----
From: Anand [mailto:info@s...]
Sent: 06 February 2003 08:18
To: ASP Databases
Subject: [asp_databases] Re: Ability to print address labels through
Intranet


HI,

If you are using asp application then why do you want your users to learn
the SQL or Access database? When you make asp program to do all jobs like
printing address's and else things then your users should know how to
operate your asp program not sql or any others database. I hope this would
make clear to you if not do write more about your application.

Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar,  Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Neile Bermudes" <Neile.Bermudes@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, February 05, 2003 11:54 AM
Subject: [asp_databases] Ability to print address labels through Intranet


> Hello,
>
> I have been asked to create a system that will allow staff to print
address
> labels for different groups of people through the Intranet. At the 
> moment, as it is a small company, staff create their own address 
> tables/databases
in
> either access or word- but this means that everyone has their own 
> source
of
> information and it is usually out of date. I have now moved our whole 
> employee database that was in Access into SQL, and would like all 
> staff to use this one source of information. Ultimately, the request 
> has been that staff should be able to, through the intranet, create ad 
> hoc groups of addresses and print these onto labels for mailouts. 
> However, I know this means me writing some sort of ASP/SQL based
> program- and due to my restrictive time line, I wouldn't mind looking 
> at other ways. However, if the application is the only way, I'll do 
> it.
>
> Originally, my idea was to create a linked table in Access (that links 
> to the SQL employee database and therefore stays up-to-date) and give
everyone
> access to this source. The good thing here is that people can stay in
Access
> without having to learn something new, the address info is always up 
> to
date
> and especially, is not hard for me to set up. The downfall is that, 
> one, I would have to create the linked table on each persons machine 
> and two, I don't know if Access can handle this especially over a 
> network connection, and potentially over long distances if our remote 
> sites are to use this database.
>
> Does anyone have any suggestions, whatever they be I would be 
> interested
to
> here them. It would be especially helpful if someone has actually 
> created
a
> system like this before or is using one at the moment. If the 
> suggestion
is
> that I do write the ASP system, please pass it on as well.
>
> Thanks a lot
> Neile
>
> --
>
> Neile Bermudes
> Network Support Analyst
> ECB IT Dept
> 020 74321241
>
>
>
> The contents of this e-mail are the property of the ECB.  This e-mail 
> (and
any attachments)
> are confidential and intended for use by the named recipient(s) only. 
> It
may contain
> confidential or privileged information.  Any opinions expressed herein 
> are
those of the
> individual and not necessarily those of the ECB. If you are not the
intended recipient would
> you please immediately delete this e-mail and any attachments from 
> your
computer system
> without publishing, copying or distributing it, and notify the sender 
> at
the ECB.  Do not
> disclose this e-mail or the information disclosed herein to any other
person, use it for any
> purpose other than intended, or copy, distribute or store the 
> information
on any medium.
> Copyright in this e-mail and attachments created by us belong to ECB 
> and
the author also
> asserts the right to be identified as such and to prevent any misuse.
Please conduct your
> own virus checks.  The ECB does not accept responsibility or liability 
> for
any virus or any
> loss or damage caused by such software virus.  Our web site is at
http://www.ecb.co.uk.
>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to 
> unsubscribe send a blank email to
>


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments) are confidential and intended for use by the named
recipient(s) only.  It may contain confidential or privileged information.
Any opinions expressed herein are those of the individual and not
necessarily those of the ECB. If you are not the intended recipient would
you please immediately delete this e-mail and any attachments from your
computer system without publishing, copying or distributing it, and notify
the sender at the ECB.  Do not disclose this e-mail or the information
disclosed herein to any other person, use it for any purpose other than
intended, or copy, distribute or store the information on any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also asserts the right to be identified as such and to prevent any
misuse. Please conduct your own virus checks.  The ECB does not accept
responsibility or liability for any virus or any loss or damage caused by
such software virus.  Our web site is at http://www.ecb.co.uk.


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error. This
e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in error
you must take no action based on them, nor must you copy or show them to
anyone; please reply to this email and highlight the error.

Security Warning : Please note that this email has been created in the
knowledge that the internet is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when emailing
us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with good
computing practice, the recipient should ensure they are actually virus
free. _____________________________________________________________________

---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments) are confidential and intended for use by the named
recipient(s) only.  It may contain confidential or privileged information.
Any opinions expressed herein are those of the individual and not
necessarily those of the ECB. If you are not the intended recipient would
you please immediately delete this e-mail and any attachments from your
computer system without publishing, copying or distributing it, and notify
the sender at the ECB.  Do not disclose this e-mail or the information
disclosed herein to any other person, use it for any purpose other than
intended, or copy, distribute or store the information on any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also asserts the right to be identified as such and to prevent any
misuse. Please conduct your own virus checks.  The ECB does not accept
responsibility or liability for any virus or any loss or damage caused by
such software virus.  Our web site is at http://www.ecb.co.uk.


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error. This
e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in error
you must take no action based on them, nor must you copy or show them to
anyone; please reply to this email and highlight the error.

Security Warning : Please note that this email has been created in the
knowledge that the internet is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when emailing
us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with good
computing practice, the recipient should ensure they are actually virus
free. _____________________________________________________________________

---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


The contents of this e-mail are the property of the ECB.  This e-mail (and
any attachments) are confidential and intended for use by the named
recipient(s) only.  It may contain confidential or privileged information.
Any opinions expressed herein are those of the individual and not
necessarily those of the ECB. If you are not the intended recipient would
you please immediately delete this e-mail and any attachments from your
computer system without publishing, copying or distributing it, and notify
the sender at the ECB.  Do not disclose this e-mail or the information
disclosed herein to any other person, use it for any purpose other than
intended, or copy, distribute or store the information on any medium.
Copyright in this e-mail and attachments created by us belong to ECB and the
author also asserts the right to be identified as such and to prevent any
misuse. Please conduct your own virus checks.  The ECB does not accept
responsibility or liability for any virus or any loss or damage caused by
such software virus.  Our web site is at http://www.ecb.co.uk.


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

_____________________________________________________________________
Please contact I.T. Support if you have received this email in error. This
e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in error
you must take no action based on them, nor must you copy or show them to
anyone; please reply to this email and highlight the error.

Security Warning : Please note that this email has been created in the
knowledge that the internet is not a 100% secure communications medium. We
advise that you understand and observe this lack of security when emailing
us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with good
computing practice, the recipient should ensure they are actually virus
free. _____________________________________________________________________



The contents of this e-mail are the property of the ECB.  This e-mail (and any attachments) 
are confidential and intended for use by the named recipient(s) only.  It may contain 
confidential or privileged information.  Any opinions expressed herein are those of the 
individual and not necessarily those of the ECB. If you are not the intended recipient would 
you please immediately delete this e-mail and any attachments from your computer system 
without publishing, copying or distributing it, and notify the sender at the ECB.  Do not 
disclose this e-mail or the information disclosed herein to any other person, use it for any 
purpose other than intended, or copy, distribute or store the information on any medium. 
Copyright in this e-mail and attachments created by us belong to ECB and the author also 
asserts the right to be identified as such and to prevent any misuse.  Please conduct your 
own virus checks.  The ECB does not accept responsibility or liability for any virus or any 
loss or damage caused by such software virus.  Our web site is at http://www.ecb.co.uk.