Hi all
At the risk of shooting myself in the foot, I have a question that is in all
certainty off-topic, but if I may flatter a few egos, I've been continually
impressed by the breadth of knowledge/experience in this NG. so, I'd be
grateful if anyhone can help and/or point in me in the right direction.
I want to take records from an Access database and perform a 'mail merge' to
print out some basic info (name, address, a currency amount (e.g. 26.26) and
a textual version of the financial amount (e.g. "Not more than 27 pounds")
onto a giro (i.e. a continuous paper feed that will be sliced up and then
posted to customers as a bankable giro.
I realise that the source of the data (Access) is immaterial to correctly
aligning the data and printing it out, but wonder whether exporting to MS
Word and then figuring out a way to output this to a dedicated printer -
correctly aligning the data and recovering from any spoiled giros would be,
lets say, a challenge. We'd be talking about c. 1000 records per print-run.
So has this idea got any legs or do I need some professional input?
Many Thanks,
Paul
6  1533 
Would you not design a report, and pint it out?
I don't see the problem here at all. You got a great report designer in
ms-access. Layout the fields/data on the report, and simply print it out,
and you are done.
It seems what you want/ask is a talor made problem for ms-access, and the
reprot writer....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com http://www.members.shaw.ca/AlbertKallal
thanks for replying Albert.
The giros are essentially a batch a paycheques & have pre-printed ID
numbers onto them (which I have no prior knowledge of) onto which I need
to 'stamp' my names & addresses therefore I can't (nor would I want to)
simulate their appearance. So replicating is out of the question.
Any thoughts?
Thanks,
Paul
*** Sent via Developersdex http://www.developersdex.com ***
Are we talking about a printing machine here?
What you said so far still does not stop, or disable the ability of using
ms-access to send out the data you need..
When you say mail merge...to what are you sending this to? Do you want to
send the results to word?
Or, perhaps the results need to be output to some file that the check
writing machine needs?
You are just not being clear here, but so far, what you ask for sounds like
a reasonable request, and is certainly within the realm of using ms-access.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com http://www.members.shaw.ca/AlbertKallal
Albert
Apologies for the ambiguity & thanks again.
your penultimate para is exactly what I need to do. At the moment, staff
type out each payee's details, this data is sent to a printer & the giro is
printed out. repeat ad nauseum.
I already have the data in Access on our network, so wanted to export this
list to some file (no problem upto here) - load it onto a stand alone pc
that's attached to the giro-printer (though I suppose it's no different from
other printers?) & away we go...
(Your suggestion however of using Access reports seems to easy to good to be
true: perhaps there is something about our giro printer that prohibits this?
From what you're saying, I suppose not)
Thanks again
Paul
"Albert D. Kallal" <ka****@msn.com > wrote in message
news:MDY3f.2004 85$tl2.195371@p d7tw3no... Are we talking about a printing machine here?
What you said so far still does not stop, or disable the ability of using
ms-access to send out the data you need..
When you say mail merge...to what are you sending this to? Do you want to
send the results to word?
Or, perhaps the results need to be output to some file that the check
writing machine needs?
You are just not being clear here, but so far, what you ask for sounds
like a reasonable request, and is certainly within the realm of using
ms-access.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
I thought maybe I'd overlooked some important aspect given the nature of
the printing material - but data is data is data- it's that simple!
Thanks again,
Paul
"Albert D. Kallal" <ka****@msn.com > wrote in message
news:QsV3f.1896 25$1i.32664@pd7 tw2no... Would you not design a report, and pint it out?
I don't see the problem here at all. You got a great report designer in
ms-access. Layout the fields/data on the report, and simply print it out,
and you are done.
It seems what you want/ask is a talor made problem for ms-access, and the
reprot writer....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Ok, so the end result is that this machine needs a "text" file of some type
in a particular order and format.
You need to grab the manual, or whatever, and find out what the machine
needs.
once you got the format, the you can
1) use the export features of ms-access to create a text file in the
correct format
2)
barring that ms-access don't have the correct export features/format, then
you can write some simple code in ms-access to OUTPUT the text file in the
format you need.
3) if the device supports windows printers, then you can make a report in
ms-access, and print directly to the device. (Your suggestion however of using Access reports seems to easy to good to
be true: perhaps there is something about our giro printer that prohibits
this?
There might be. The printer might require a "text" only file (remember the
old dot matrix printers...they did not accept fonts, and graphics...but only
text data, and often, they could not work with windows).
If that giro printer supports windows output, then you likely can drive it
directly from ms-access (a reprot). If it does not support windows, then we
would generate the text file from ms-access, and then let the giro printer
chew on the text file.
From what you're saying, I suppose not)
Like I say, it is not 100% clear which of the two options we have to use
(but, at least we got the options!!)
I would just take a quick look at the manual, it should explain/point out
how to send data to the unit...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com http://www.members.shaw.ca/AlbertKallal This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Kevin King |
last post by:
I have a question about an assignment I have. I need to count the
number of comparisons in my merge sort. I know that the function is
roughly nlog(n), but I am definately coming up with too many
comparisons. It seems to me like I should just use a single counter in
the merge function's 'if' statement, but this can't be right because
an array of 50 takes about 100 comparisons this way. If anyone has any
suggestions I would greatly...
|
by: Traci |
last post by:
I need to do a mail merge letter from my database. The letter will be addressed
to small companies and in the body of the letter I need to list employees of the
company. There will be from 1 to 15 employees. My database is all set up to
provide the names and addresses of the companies and the list of employees of
each company. I need help on how to do the employee merge field when there will
be multiple employees to be listed in this field....
|
by: Squirrel |
last post by:
Hi everyone,
I've created a mail merge Word doc. (using Office XP) , the data source is
an Access query.
Functionality I'm attempting to set up is:
User sets a boolean field to true for each person for whom a mail
merge letter is desired.
The query reads address info from the table for each record where is
true.
|
by: Neil Ginsberg |
last post by:
I have a strange situation using Access to automate a Word mail merge. Using
Access 2000 and Word 2000, the code opens Word, opens the document in Word,
sets a table
in the calling Access application as the data source, and then performs a
merge. Everything works fine.
However, when a user uses it in Access 2002 and Word 2002, an extra instance
of the Access application is opened and remains open at the end. Sometimes
it remains open
|
by: Mike Stephens |
last post by:
A contact management application we previously developed for a customer now
has a requirement to perform mail merging. Normally request like this would
be very simple to solve, we were just point the mail merge data source to
the database. But this request is a little bit different. The customer
needs to perform the mail merge from the contacts in a dataset.
Example
In the main contact window the client has the ability to filter contact...
| | |
by: ckirby |
last post by:
I've inherited an application for creating mail merges from an Access
2003 ADP that needs an overhaul.
To generate the mail merge , the app uses a shell command:
result = Shell(str, vbHide)
where str = "C:\Program Files\Microsoft Office\Office\Winword.exe " &
letter & " /mmergeletter"
|
by: rkk |
last post by:
Hi,
I have written a generic mergesort program which is as below:
---------------------------------------------------------
mergesort.h
-----------------------
void
MergeSort(void *array,int p,int r,int elemSize,int(*Compare)(const
void *keyA,const void *keyB));
|
by: crealesmith |
last post by:
Firstly, I have no problem with mail merging to Word, VB code for that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source that
is selecting the 3 records, all of the data is shown but spread over 3
pages in the mail merge, but needs to be listed together in one
paragraph.
Is there anyway of looping through the 3...
|
by: mqueene7 |
last post by:
below is my code for my merge sort but I can't get it to sort properly. I am trying generate random numbers based on input from the user and then sort those random numbers. Can you tell me what I am doing wrong?
void merge(int,int,int);
void merge_sort(int low, int high)
{
int mid, temp;
if (low==high)
return;
if (low+1==high)
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
