Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-21-2020, 11:33 PM
Ndev777 Ndev777 is offline Mail Merge from specific worksheet with custom VBA popup Script? Windows 10 Mail Merge from specific worksheet with custom VBA popup Script? Office 2019
Novice
Mail Merge from specific worksheet with custom VBA popup Script?
 
Join Date: May 2020
Posts: 2
Ndev777 is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 05-22-2020, 04:37 AM
macropod's Avatar
macropod macropod is offline Mail Merge from specific worksheet with custom VBA popup Script? Windows 7 64bit Mail Merge from specific worksheet with custom VBA popup Script? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 05-22-2020, 04:56 AM
Ndev777 Ndev777 is offline Mail Merge from specific worksheet with custom VBA popup Script? Windows 10 Mail Merge from specific worksheet with custom VBA popup Script? Office 2019
Novice
Mail Merge from specific worksheet with custom VBA popup Script?
 
Join Date: May 2020
Posts: 2
Ndev777 is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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
Mail Merge from specific worksheet with custom VBA popup Script? Custom Mail Merge luke Mail Merge 1 04-09-2013 03:10 PM
Mail Merge from specific worksheet with custom VBA popup Script? specific mail merge cmccabe Mail Merge 3 06-14-2012 04:12 PM
Mail Merge from specific worksheet with custom VBA popup Script? Word mail merge from a protected Excel worksheet Platform Mail Merge 10 09-28-2011 05:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft