Print Mailing Labels For Several (but Not All) Clients - Newbie
Jul 4, 2006
Hi all,
I've been struggling with this for a few hours... I sure hope that the solution to my problem is complicated so I don't feel really dumb!
I'm trying to design a database to eliminate the HOURS that my mom spends trying to format mailing labels in Word. She deals with about 50 clients at a time, and sometimes needs to print labels for just a selection of them, but not all. I'd like to design a form where she can select (using an option button or similar) the clients for whom she wants to print a label, and print them all at the same time (rather than printing one at a time, which I can handle on my own). Creating mailing labels will be the only function of the db so the info stored in it will be relatively simple.
I have the Northwinds db installed, and I've found the sample Macro controlling the Where condition for the labels report. I understand how to make it work for a single selection from a combo box (ie: only print labels for customers from a specific country)
I have my report set up so it shows a label for each client, pulling data directly from the main table. No troubles with formatting. **knocks on wood**
My problems:
1. I searched this site and found a link to the MS KB file that outlines how to print multiples of one label or skip used labels before starting to print (Q95806 - "How to Skip Used Mailing Labels and Print Duplicates"). I'd like to use this, but can't make it work.
2. I can't figure out how to "link" the option button to the client name as it's listed in the form, and then tell the report to only print labels for the selected clients.
I have very little coding experience but I can make some simple code work and am OK at customizing pre-written code to my own needs if it's well commented, so VB isn't entirely out as an option.
I have a possible solution in mind that involves creating a query that makes a new table with only the selected clients, which is then used to make the labels report. I think I could make that work if I could just figure out how to select the clients in the first place.
I apologize in advance if this has been taken care of elsewhere. I tried to find it, but had trouble coming up with the right search string!
Thanks in advance,
~ Mel ~
p.s. I'm using Access 2000.
View Replies
ADVERTISEMENT
Dec 17, 2004
Access 97.
Not sure if this is the right area to post this question in, but here goes....
I want to print mailing labels but I only want to print selected names from my database, not every name in the database.
How do I do this?
Make it simple, please.
Thanks.
View 1 Replies
View Related
Feb 15, 2007
Is it possible to change the format of the mailing labels once the report has been created? I have one that has 24 labels on it, but I need for it to have 30.
Also I can't remember how I created it in the first place. What steps do I need to go through to make a new report?
View 1 Replies
View Related
Dec 13, 2005
Hi
I have created a report for labels using the Label Wizard, and found the code on the MS KB about skipping the labels that have already been used, and printing on the next one along.
Page on MS KB (http://support.microsoft.com/?kbid=299024)
When I try using this code in Access 2003 however, it seems to go into some sort of loop, and produces 100+ pages for the report when I try and skip 1 label for example.
Can anyone help me get this working for 2003?
Here's my module code, same as on the site above:
'************************************************* ********
'Declarations section of the module.
'************************************************* ********
Option Compare Database
Option Explicit
Dim LabelBlanks&
Dim LabelCopies&
Dim BlankCount&
DimCopyCount&
'================================================= ========
' The following function will cause an input box to
' display when the report is run that prompts the user
' for the number of used labels to skip and how many
' copies of each label should be printed.
'================================================= ========
Function LabelSetup()
LabelBlanks& = Val(InputBox$("Enter number of used labels to skip"))
LabelCopies& = Val(InputBox$("Enter number of copies to print"))
If LabelBlanks& < 0 Then
LabelBlanks& = 0
If LabelCopies& < 1 Then
LabelCopies& = 1
End Function
'================================================= ========
' The following function sets the variables to a zero
'================================================= ========
Function LabelInitialize()
BlankCount& = 0
CopyCount& = 0
End Function
'================================================= ========
' The following function is the main part of this code
' that allows the labels to print as the user desires.
'================================================= ========
Function LabelLayout(R As Report)
If BlankCount& < LabelBlanks& Then
R.NextRecord = False
R.PrintSection = False
BlankCount& = BlankCount& + 1
Else
If CopyCount& < (LabelCopies& - 1) Then
R.NextRecord = False
CopyCount& = CopyCount& + 1
Else
CopyCount& = 0
End If
End If
End Function
Thanks
View 7 Replies
View Related
Jan 2, 2008
I have a table that contains a lot of different information regarding to mailing.
There are columns for Name, Address, Address2, Address 3, City, State, Zip, Country, Base Name, etc.
Some units will only required parts of the above information. I'm using the Name as an identifier in the DB only and Address is the beginning of content that I want to use.
My issue stems out of the fact that the City, State, and Country are not always required but the Base Name, may be used in lieu of the City.
I was looking at making checkboxes next to each of the columns on the form on the field and then using those checkboxes somehow to create a report for Mailing Labels.
I'm just not sure how to set this up.
View 5 Replies
View Related
Jan 21, 2005
Hi--I have a contact database, and would like to be able to have a command button on the form for each contact to print one individual mailing label for that particular contact, preferably in a user-specified row/column on a page of Avery 6245 labels. Am realizing that this is a major hassle in Access but would like to do it within Access (why is it so easy to print huge lists of labels but so hard to print just one??). Any help would be appreciated. I'm pretty good at writing queries and reports in Access but a rank newbie at the underlying SQL and VBA so need major handholding if that's involved (and I know it is ). Thanks.
tdp
View 7 Replies
View Related
Feb 23, 2005
Hi there,
I have created a form containing contact details for a 100 or so different people/companies. I want to have a button that will allow me to print an address label for the current displayed record (e.g. when I find the company I wish to contact in my form I wish to click [Print Label] and then get this company's address printed on my label).
Have some programming experience but not sure how to go about this in access?
Also as an aside question, is it possible for me to display a list in my form instead of individual records. What I mean is that I would have Name, Address, etc as titles accross the top and then would have a list of all records below these. Then I could click on a record to get more detail and also click on one of the titles to re-order the data by this field?......I know these are pretty big questions but a pointer to somewhere with this info or a sample app doing something similiar would be great. :)
Thanks for your time, regards,
Lavaghman
View 2 Replies
View Related
Feb 22, 2013
I have to develop a software that allows users to print data from a GUI. The GUI is a form containing several fields: the user can choose only the fileds he wants to print (I thought to a checkbox to choose the needed fields)
For each field the user can specify: font, x,y coordinate to locate it into the label to be printed
The user can decide also the format (height,width dimensions) of the label
I imagine that the great difficulties is to find the function to create the string to sent to the printer....
View 1 Replies
View Related
Jan 28, 2014
I have an Access database that includes a customer listing. My client would like me to include a button on a form that prints off all of their customers' names and addresses onto mailing labels. I know how to do it manually by clicking on the Customers table, clicking Labels under the Create ribbon, selecting the fields, selecting the label manufacturer, size, etc. etc., but the customer would prefer to have just one single button.
I've looked everywhere for VBA code to put into a macro that does this. Unfortunately, unlike Excel, Access doesn't have a "Record Macro" option so I can attach it to the button.
Table: Customers
Fields: FirstName LastName Address City State Zip (There are other fields, but they are not relevant to printing address labels)
View 1 Replies
View Related
Mar 1, 2013
I need to print a contiguous subset of records from a table, not the whole table. I'm using a standard Avery #5349 label page, but need to print them in a vertical orientation (2 1/3" wide x 3 3/8" high; 4 across w/2 down), so I have to create a custom landscape label to print on regular 8 1/2" x 11" paper, but defined as landscape 11" x 8.5". When I do Print Preview, and orient the printer to Landscape, the Print Preview still shows Portrait, so I'm losing labels off the right side of the screen.
I know I can export the table to an Excel spreadsheet (to be used by Word's label print functions); the custom label page definition there is correct, and the labels print correctly. But I'm trying to simplify the whole operation by printing the labels from Access.
1. When designing the Access custom label definition, the Edit Label page graphic doesn't reorient and redimension the labels' layout as I enter each label dimension (as it does in Word), so I'm not sure which dimensions are correct (I've tried both ways). When I go for the Print Preview (and specify that the printer is to honor Landscape mode), I'm told that the dimensions won't fit on the page .. and I've seen the messages that say to ignore this if printing multiple labels .. "it'll probably print OK." Do I just (in my mind) rotate the graphic 90 and enter the measurements as I do in Word?
2. I haven't gotten to this point in Access yet: can I format each field differently (font, size) in the 1st label, then replicate that label's design across all (as in Word), then fill with data from the table?
3. I'm a DB lightweight .. how to select a range of records from a table to print to the labels? I don't want to print the whole thing.
4. Similar to #3: if I decide to export a table to a spreadsheet for input to Word, how to export just a range of records? I've been exporting the whole table, then editing the spreadsheet to delete the unwanted records, before inputting it as the Recipient List to Word's label print functions.
I'm trying to develop the necessary techniques at home on my Windows 7, Office 2010 platform. When I get it all figured out, I'll try to implement it on the target platform: my church's XP Office 2007 environment.
View 1 Replies
View Related
May 8, 2013
I am using access 2010 and have made a simple database for the company I work for. This consists of the a table of the raw data and a form to make the data printable.
I have been asked by our admin person if I can make it possible to be able to print labels from it. I know it is possible via the wizard but very limited.
What we really need is to be able to select the people from the table that we want labels for.
I have added a true/false check box to the table called 'label?'
View 7 Replies
View Related
Jul 11, 2015
I am having a problem setting the margins to print labels in access. I go to page setup and change the margin size click ok and nothing happens to the label and when I go back to page setup the margins have returned to their original values. I have already selected the label printer and labels that im using.So im baffled as to why it wont accept margin values that don't cause the label to be printed over 3 labels.
View 1 Replies
View Related
Apr 18, 2014
I have a form where I'd like to create a button to print labels from a labeling program called Label Matrix. I already have the label set up in Label Matrix to draw info from the Access table, and I know how to create a button. I can't figure out how I would make the button print the label.
View 5 Replies
View Related
Jul 22, 2014
I am printing invoices and need to print the label in a subreport at the end of each customer only once. This is what I want it to look like:
2014 payments applied to cap: GA $8,078.00
NC $1463.00
SC $155.00
NOT
2014 payments applied to cap: GA $8078.00
2014 payments applied to cap: NC $1463.00
2014 payments applied to cap: SC $155.00
I use ACCESS, but I do not know SQL. .
View 5 Replies
View Related
Jul 5, 2015
I have a button on a form which is used to print shipping labels. This button runs a Query and then a report using the code below.
Private Sub SaveBtn_Click()
DoCmd.SetWarnings False
DoCmd.RunSQL "Update BookInTable SET DateBookedOut = '" & Me!DateTxt & "' WHERE BarCode ='" & Me![BarTxt] & "'"
DoCmd.RunSQL "Update BookInTable SET BookedOut = True WHERE BarCode ='" & Me![BarTxt] & "'"
DoCmd.OpenQuery "PrintLabelQuery"
DoCmd.OpenReport "Labels", acViewPreview
DoCmd.PrintOut , , , , 1
DoCmd.SetWarnings True
End Sub
But I need both the query results and the report to not be seen. All I want to happen when clicking the button is that a label is printed.
View 5 Replies
View Related
Jan 12, 2015
I have always noticed that when creating a report, when you make a paragraph using a label, the alignment and size of the text/paragraph is always different when you preview the report than when you design it.
This makes alignment of paragraphs tricky, especially when you are trying to insert a bold faced word into the middle of a block of text by using a separate label.
I am using Access 2000
View 4 Replies
View Related
Jun 10, 2005
Thought I posted this once before, now can't find it -- so I apologize if it turns out to be a duplicate posting.
Anyway...Figured out how to design a table then extract the info I wanted via a query. Last thing I simply cannot figure out is how to get the query exported onto mailing labels.
Thank you in advance to anyone willing to share their time and expertise to assist me in this last step.
View 2 Replies
View Related
Dec 25, 2006
I have a table -'client' with 5 fields,
id
name
address
email
mobile no
I want to see only those clients who has email id.
I know its simple but not so simple to a layman like me :)
Please help
View 3 Replies
View Related
May 10, 2007
Hi, all!!
I need to generate 1 email with 3 attachments from an Access Db. These attachments are canned reports that are generated each week with fresh data.
I've done several searches and found a lot of good information here. Based on what I've read, I decided to output the 3 reports to a folder in My Documents and then automate Outlook to send the message.
I've used the output function to create the 3 files. No Problem, works well.
Then I found this code for automating Outlook. (Pasted below)
I can get it to work (following either step 7 or step 8 below) but only if I include the attachment path in the SendMessage command.
Assuming the full paths are:
C:My DocumentsReport1.snp
C:My DocumentsReport2.snp
C:My DocumentsReport3.snp
how do I modify the code to automatically attach all 3 files?
Any ideas?
As always, thanks for taking the time to help,
BeckieO
Sub SendMessage(Optional AttachmentPath)
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim objOutlookAttach As Outlook.Attachment
' Create the Outlook session.
Set objOutlook = CreateObject("Outlook.Application")
' Create the message.
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
With objOutlookMsg
' Add the To recipient(s) to the message.
Set objOutlookRecip = .Recipients.Add("Henny Penny")
objOutlookRecip.Type = olTo
' Add the CC recipient(s) to the message.
Set objOutlookRecip = .Recipients.Add("Lucky Ducky")
objOutlookRecip.Type = olCC
' Set the Subject, Body, and Importance of the message.
.Subject = "This is an Automation test with Microsoft Outlook"
.Body = "Last test - I promise." & vbCrLf & vbCrLf
.Importance = olImportanceHigh 'High importance
' Add attachments to the message.
If Not IsMissing(AttachmentPath) Then
Set objOutlookAttach = .Attachments.Add(AttachmentPath)
End If
' Resolve each Recipient's name.
For Each objOutlookRecip In .Recipients
objOutlookRecip.Resolve
If Not objOutlookRecip.Resolve Then
objOutlookMsg.Display
End If
Next
.Send
End With
Set objOutlookMsg = Nothing
Set objOutlook = Nothing
End Sub
7. To test this procedure, type the following line in the Immediate window, and then press ENTER: SendMessage "C:My DocumentsCustomers.txt"
8. To send the message without specifying an attachment, omit the argument when calling the procedure, as follows:SendMessage
View 3 Replies
View Related
Jul 21, 2005
I have a database of customers for which I want to print address labels depending on what group I have entered them in. There are about 30 different groups that they could be a member of. I have entered them in to groups by using "yes/no" fields on the customer table to indicate who is a member of which set. My problem is that I know how to indentify which group is required using sql
eg select surname,address from table where GP
where GP is one of the possible groups. I cannot however see a way of selecting the group variable from a form and entering into a query, so that I can print the required label set.
Can anyone please advise me on this or point point me in the direction of an example. I tried using a combo box on form but could not get it to pass the parameter correctly. Many thanks in advance.
Regards
Peter
View 1 Replies
View Related
Jul 29, 2005
I have a database with a list of clients, their enter and exit dates. I need to do a query that will count how many clients we have on a specific date. Keeping in mind that clients leave. I can do a query that will prompt user to enter a date. However, how would I count the total number of clients on that date? thanks a lot for any help!
View 3 Replies
View Related
Feb 3, 2007
I have a database for clients and have set up a form and code to run a query for different types of clients and to send emails to the group.
Everything works fine until I try to send and then I get a Microsoft Outlook pop-up which states:
"A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No."
This message stays for 5 seconds and then I can click on "YES" and it will send the email, and start all over for the next recipient.
I am assuming this is an Outlook Spam Blocker, but is there any way to stop it?
Thanks
View 1 Replies
View Related
Nov 29, 2006
:( Hi Guys,
I have a very basic DB of customers names and addresses. What I want to do is find all the enquiries within the months of August, September and October, send all these enquiries to a new table so that I can use this new table for a mailshot.
The date of the incoming enquiry is in a field on it own and written as dd/mm/2006.
If there is an easy way to create a mailing list from the original table please let me know.
Best Regards
Keith:o
View 1 Replies
View Related
Aug 23, 2007
I am preparing mailing label for a political campaign. On my list of voters, many times two or more people are listed at a single address. By consolidating the labels (and postage) I am able to save a lot of money.
I have written a query to group these names into those with 1,2, or 3 or more/address. For labels I am able to print 2 names/label by using the FirstOfFirstname, FirstOfLastname, LastOfFirstName, LastOfLastName generated in my query. This works fine for 2 names per label.
My question concerns 3 names per label. Does anyone know how to include all 3 names? Suggestions have included using a label with "The {LastName} Family" etc. but many times there is more than one last name per residence. Other suggestions are to print individual labels for each individual and overlap the labels to show all the names but just one address. These does save postage of $.42/mailing, but seems wasteful of labels and looks a little crude besides.
What I think I need is a clever query or queries that will be the data source for the labels. I have room for up to 3 names/label. I have been thinking about printing 2 labels -- one with one name and address and another with the rest of the names but this brings up problems of getting everything on the right envelope.
View 2 Replies
View Related
Oct 11, 2006
Hi All,
I have attached a DB that I am trying to create for my small business. Every month we have renewals of the client’s yearly contracts. I have created a form called frmRenewells, on this form you need to select a month and a year (please choose October 2006) this then runs query qryRenewell. The query then opens form frmRenewellSheet with the results. This works fine, but I really need the following to happen:
Open form frmRenewells and enter month & year, on clicking the enter button it launches a word template I have created and automatically pulls all the fields required into the word document. I can then press print and it will print a document for each client in the query.
I am unable to go into word and just open the query as it has * or wildcards in it. Therefore word will not allow me to select the query.
I have attached the Word doc as well
Thanks in advance,
Danian
View 1 Replies
View Related
May 14, 2004
I need to e-mail weekly reports to several parties, but both Word and Excel are not working for me because I am losing the original formatting. For the sake of consistency and readability I need to preserve the original report format, but I am totally stumped as to how to do this. Please, someone, help!
View 3 Replies
View Related
