+ Reply to Thread
Results 1 to 2 of 2

Mail Merge - Create separate Mail merge pdf for each sheets of an excel file

  1. #1
    Registered User
    Join Date
    03-12-2021
    Location
    Trivandrum, Kerala
    MS-Off Ver
    2007
    Posts
    1

    Question Mail Merge - Create separate Mail merge pdf for each sheets of an excel file

    Hi all,
    I create a Mail Merge in WORD, using the database of excel. I have around 100+ sheets in that excel file . I need to generate seperate Mail Merge pdf for each sheets. Can anyone help to create VBA for the same?

    Regards
    Suresh Babu

  2. #2
    Banned User!
    Join Date
    01-17-2021
    Location
    Omaha, NE
    MS-Off Ver
    office 2016
    Posts
    211

    Re: Mail Merge - Create separate Mail merge pdf for each sheets of an excel file

    how you want to generate? saveAs? mail merge makes docx file and many pages in one file. that what you doing now? my first guess is that you have to run 100 mail merges and saveAs every one, one page at time, as pdf file. but can you not export excel sheet singles to pdf file? i think you can. can you save page by page in ms word as file type? you should be able to do that too I think. maybe not. i dont remember seeing anyone else do that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Mail Merge to create separate PDF documents
    By Phlegon_of_Tralles in forum Word Formatting & General
    Replies: 9
    Last Post: 03-30-2021, 10:57 AM
  2. [SOLVED] Mail merge with many different sheets of the same excel file?
    By minhys1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2020, 03:36 AM
  3. Replies: 0
    Last Post: 09-11-2015, 09:11 AM
  4. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  5. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  6. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  7. [SOLVED] How do I create a mail merge document in Excel? Is it possible?
    By Plbowles in forum Excel General
    Replies: 6
    Last Post: 12-19-2005, 03:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1