Results 1 to 4 of 4

Thread: Mass Mail Merge Problem - Is there a limit on the MailMerge document size?

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    11

    Mass Mail Merge Problem - Is there a limit on the MailMerge document size?

    Hi,

    I am using VS 2005. In the initial process of mail merge, if we want to merge 100 records, we will send it one by one for which the windows application stays open throughout the process and the documents will open and close for each record.

    Now we are trying to merge all 100 records in a single document, each record being on a different page in the document. I debug and see 100 records are being merged, but when I view or print the document, only 7 records are displayed. If I try to merge anything more than 7 records, only first 7 get displayed or printed.

    Is there any limit on the size of the document that can be created?

    Thanks in advance.

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Mass Mail Merge Problem - Is there a limit on the MailMerge document size?

    Not that I have seen but it sounds more like a possible coding issue where the doc prints or closes before the recordset has completely populated or merged.

    Can you post some of your code?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  3. #3

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    11

    Re: Mass Mail Merge Problem - Is there a limit on the MailMerge document size?

    Hi,

    It was a coding problem. The MailMerge documents LastRecord property was set to the number of data fields to be populated instead of the number of records to be merged. Problem solved.

    Thanks.

  4. #4
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Mass Mail Merge Problem - Is there a limit on the MailMerge document size?

    Np,

    Ps, dont forget to Resolve your thread
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width