Results 1 to 2 of 2
  1. #1
    txacoli is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2010
    Posts
    19

    Struggling with MailMerge

    Hi


    Very occasional Access user here, so apologies for my naïveté.

    I have a database that I use for submissions for our local radio station. Pluggers send us MP3s and as the Submissions Editor, I go through them and decide what is to go on the playlist and what won’t (you should hear some of them - sheesh!!) Anyway, most of it works fine, but I want to create a list of all the information to send to the presenters. Like so…

    Song title
    Artist
    Style (of music)
    Information from Plugger

    That way, each presenter would know what sort of style would suit their programme and could pull from the list. I’m struggling with MailMerge for this, as it creates one page for each DB entry. Is there any way of doing it so that I can use the DB to pull around 20 (each week) records into one document to create this list???

    Thanks

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,773
    Why not create a report?, why does it need to be a Word document?
    Use a label document if you insist on a word document.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. word mailmerge with access/sql
    By roberto21 in forum Access
    Replies: 3
    Last Post: 10-18-2020, 09:43 AM
  2. Access VBA MailMerge.OpenDataSource
    By atlasinformatique in forum Programming
    Replies: 1
    Last Post: 11-05-2016, 06:06 AM
  3. MS Access and MS Word MailMerge
    By tgall in forum Access
    Replies: 1
    Last Post: 11-14-2015, 11:02 PM
  4. Access and Word MailMerge
    By saharmon in forum Access
    Replies: 0
    Last Post: 10-28-2014, 02:37 PM
  5. Mailmerge Current Record...
    By oakleyp2 in forum Programming
    Replies: 0
    Last Post: 02-22-2006, 08:08 AM

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