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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks