Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-15-2018, 08:00 AM
mark_kofi mark_kofi is offline Windows 10 Office 2010 64bit
Novice
 
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, 2 views)
File Type: docx BUSINESS PLAN SUBMISSION word doc.docx (15.2 KB, 2 views)
Reply With Quote
  #2  
Old 07-15-2018, 09:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,365
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Links added by OP as requested - Thx
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.

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 Windows 10 Office 2010 64bit
Novice
 
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 Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,365
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
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.
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #5  
Old 07-17-2018, 03:49 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,191
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[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
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


All times are GMT -7. The time now is 01:24 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft