Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-15-2018, 08:00 AM
mark_kofi mark_kofi is offline Excel to word Mail Merge problem Windows 10 Excel to word Mail Merge problem Office 2010 64bit
Novice
Excel to word Mail Merge problem
 
Join Date: Jul 2018
Posts: 2
mark_kofi is on a distinguished road
Default Excel to word Mail Merge problem

Hello community, first time poster




I have a mail merge Excel to word problem.


I have designed a business case template that various agents use. Various questions out of a total of 21 have to be answered depending on the agent type.


The answers then feed a Word submission final business case document.
The issue I'm having is that I'm not supposed to have any unaswered quetions in teh final document, e.g. if questions 12, 15, and 18 in the word document are not requred then these need to be automatically removed from the word documents and the hence the size adjusts to fill the blank space.


Thanks in advance.
Attached Files
File Type: xlsx Agent Business plan templatre.xlsx (11.3 KB, 9 views)
File Type: docx BUSINESS PLAN SUBMISSION word doc.docx (15.2 KB, 9 views)
Reply With Quote
  #2  
Old 07-15-2018, 09:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel to word Mail Merge problem Windows 7 64bit Excel to word Mail Merge problem Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Links added by OP as requested - Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Last edited by Pecoflyer; 07-17-2018 at 09:17 AM.
Reply With Quote
  #3  
Old 07-17-2018, 06:39 AM
mark_kofi mark_kofi is offline Excel to word Mail Merge problem Windows 10 Excel to word Mail Merge problem Office 2010 64bit
Novice
Excel to word Mail Merge problem
 
Join Date: Jul 2018
Posts: 2
mark_kofi is on a distinguished road
Default Links to other post provided

Apologies, I did not realise I could not cross post without links.

Well I consider myself well and truly told off. Links to other posts.

https://www.ozgrid.com/forum/forum/h...-case-document
https://www.mrexcel.com/forum/excel-...-document.html
https://www.reddit.com/r/excel/comme...name=frontpage

Given that you've told people NOT TO ASSIST ME I'm guessing they not will not even though the links are there.
Reply With Quote
  #4  
Old 07-17-2018, 09:21 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel to word Mail Merge problem Windows 7 64bit Excel to word Mail Merge problem Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by mark_kofi View Post

Given that you've told people NOT TO ASSIST ME I'm guessing they not will not even though the links are there.

As you can see that post has been deleted.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 07-17-2018, 03:49 PM
macropod's Avatar
macropod macropod is offline Excel to word Mail Merge problem Windows 7 64bit Excel to word Mail Merge problem 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

You might at least do the basic mailmerge setup before asking others to help solve the problem. Your workbook (which isn't laid out appropriately for a mailmerge) implies all questions must be answered, so it's not apparent what you mean by some being 'not required'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
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
Excel to word Mail Merge problem Problem with Word Mail Merge VBA - Outlook Object Library not recognized shawnhet Word VBA 2 04-15-2015 07:51 AM
Word 2003 mail merge problem.. hotice121 Mail Merge 2 03-17-2011 11:57 AM
Word 2007 Mail Merge Problem flambe99 Mail Merge 2 04-20-2009 11:58 AM
Word 2007 mail merge problem Katyone Mail Merge 0 05-13-2008 04:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:36 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