#1
|
|||
|
|||
Mail Merge from specific worksheet with custom VBA popup Script?
Hi guys and gals,
Unfortunately for me, I am Excel and Word technically challenged I humbly seek the wisdom of you amazing people... I am trying to help a friend who is an accountant and like me, also has no clue in achieving this mail merge feature.. Trying to accomplish: A word document that would fill mail merge the respective fields, but it would work from either one, several, or all worksheets available. In the Excel screenshot examples below, I've listed two worksheets business's by their "Code", BBB and FPP, which represents the business's (Bob's Burgers and Frankies Pizza) In the Word screenshot below, you can see that I have the written and inserted the fields I want populate. What I'd like to have, upon opening the Word document that is linked to that excel file, is a popup box (VBA script?) which asks... Type in Code(s), seperated by a comma to mail merge, or a "All Codes" mail merge. I've included a photoshop "Mock-up" screesnot to give an example... Is this do-able? Thank you all who reply in advance Warm regards, Val screen-1 — ImgBB screen-2 — ImgBB word — ImgBB word-popup-mockup — ImgBB |
#2
|
||||
|
||||
That's not going to happen without a lot of effort. A mailmerge can only work with a single data source - in this case a single worksheet. Besides which, it's not apparent what the purpose is behind having different worksheet names in column C when both sheets appear to be in the same workbook.
What is the problem with a having different mailmerge main document for each data source?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you for your reply,
The problem is the main data source has well over 50+ worksheets, which would mean you would need to have 50 separate files, which points to the right worksheet for each separate client.. (and counting as more clients come along), this of course can be achieved, creating all those files, but its not ... shall I say, a elegant solution to the problem... But I completely agree, this is a huge monumental task or some real wizardry VBA script needed, to which I have no idea how to do... In any case, thank you for taking the time to reply. Regards, Val |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA | RMerckling | Mail Merge | 16 | 05-17-2018 05:19 PM |
How do I mail merge just part of one worksheet | tomseeley | Excel | 0 | 01-25-2014 12:10 PM |
Custom Mail Merge | luke | Mail Merge | 1 | 04-09-2013 03:10 PM |
specific mail merge | cmccabe | Mail Merge | 3 | 06-14-2012 04:12 PM |
Word mail merge from a protected Excel worksheet | Platform | Mail Merge | 10 | 09-28-2011 05:12 AM |