Results 1 to 10 of 10
  1. #1
    Angeline is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2015
    Posts
    5

    Exclamation Mailing labels for 'no-email' records ONLY

    I'm somewhat new to Access and I have to print mailing labels for everyone from a table that does NOT have an email. They will get snail mailings vs. email. I thought I knew how to make this mailing label query and report, but I keep getting EVERYONE still on the report and print out preview. How would I make the labels print ONLY those in the table that DO NOT have an email listed?

    Also, I noticed when I print preview the labels I selected for {NAME} {LASTNAME} yet it doesn't show their names. Instead, shows *type - something like this. How do I get it to SHOW their names for the labels?

    Thank you and sorry for my beginner level-ness.



    Angel~

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Don't know your data structure so can't be specific.

    Perhaps you need to include another table that has customer info in the report RecordSource query.

    Apply filter criteria to report when opening. In VBA would be like:

    DoCmd.OpenReport "Labels", , , "Email Is Null"

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Angeline is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2015
    Posts
    5

    Smile Address labeling

    Quote Originally Posted by June7 View Post
    Don't know your data structure so can't be specific.

    Perhaps you need to include another table that has customer info in the report RecordSource query.

    Apply filter criteria to report when opening. In VBA would be like:

    DoCmd.OpenReport "Labels", , , "Email Is Null"

    If you want to provide db for analysis, follow instructions at bottom of my post.
    ---------
    Data Structure, I think you mean "Name" "Lastname" "Department" "Street" etc, right? That is the structure I have in place. I am trying to print mailing labels in an Avery template, and I only want to print these labels for the contacts I have in the table that do NOT have emails. To save on printing. Don't want to print labels for the other 500 people who I will be instead emailing after I take care of my snail mail contacts.

    I'm looking to see how I make a query converted to Labels that ONLY print the entries with NO emails listed. Any instructions?

    Thank you,
    Angel

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    So where is the field that has email address? Include it in the report RecordSource. Apply filter as described.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Angeline is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2015
    Posts
    5
    Sorry, I don't understand "Include it in the report RecordSource"

    I know that when I filter it in the query it still shows emails...

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What is not clear about 'include it in the report RecordSource'? Include fields in the report's RecordSource that are needed to accomplish this task. RecordSource property can reference a table or query object or can be an SQL statement.

    Post query SQL statement.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Angeline is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2015
    Posts
    5
    I was wondering that was what you meant 'table' or 'query' etc. I understand now. So I tried this and it worked. I did notice that once I placed the filter on the column itself, I also had to select the advanced button under Home tab at top, and then had to select "Apply filter/sort" in order for it to actually activate the command.
    So that has been solved.

    Thank you so much for your patience with me as a beginner, and helping me solve these steps.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I don't use dynamic parameters in queries. I use the VBA approach.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    Angeline is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2015
    Posts
    5
    I don't know what VBA means, sorry. I'm really that much of a beginner.

  10. #10
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Visual Basic for Applications - it is programming language packaged with all MS Office apps.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-29-2013, 02:36 PM
  2. Linked Data Bases for Mailing Labels
    By Kennertoy in forum Access
    Replies: 6
    Last Post: 03-20-2013, 02:26 PM
  3. Mailing labels formatting
    By Keith Sayers in forum Reports
    Replies: 11
    Last Post: 01-01-2013, 01:13 AM
  4. Centering Mailing Labels if line is Blank
    By shane201980 in forum Reports
    Replies: 4
    Last Post: 10-24-2012, 09:00 PM
  5. Mailing Labels from a Search Form
    By waltb in forum Access
    Replies: 4
    Last Post: 03-08-2012, 06:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums