I have a spreadsheet that contains information I want to use to fill out a form, Mad Libs style. Essentially, I'd take each row of the spreadsheet and use the cells to populate a text document. It's not actually in Excel/Word - it's in Libreoffice, if that changes anything. I also need room for conditional if-then statements, because some text may require additional accompanying notes.
I tried generating a pdf in Nandeck (card game generation software) but that doesn't work well for formatting text relative to other text, so I'm looking for a better solution.
posted by LSK
on Sep 8, 2014 -
I'm using Excel and Word 2007. Created Excel docs, created Word docs, certain cells in the Excel docs have data that must be embedded in the Word docs. This has been discussed here before, but only the method of creating these links (which was my method) but I'm just checking to see if anybody knows how to make this work when you move the document. All the links appear to be hardcoded absolute links to the Excel doc. Works fine on my PC, breaks on yours. Any way to get this functionality to be portable? [more inside]
posted by stupidsexyFlanders
on May 22, 2014 -
I have a batch of mixed-format data including long-form text fields, hyperlinks, number and plain text in an Excel doc. I have assembled a Word catalog merge file intended to allow me to proof the data manually. There are 42 records.
On merge, the output document results in what appears to be the correct number of pages and records. However, records 28-42 do not appear to place any data in the destination document. [more inside]
posted by mwhybark
on Apr 15, 2013 -
ExcelFilter: I have a whole bunch of excel files. More than 100 of them. Each file has about one page of print area, but some in portrait and others in landscape. They are mostly text in cells; not a lot of formulas being used. I would like to (1) merge all these files into one Word document; (2) have a page break so that each file (more or less) is one page; and (3) do it with a minimum of cutting and pasting. Opening everything as a PDF and viewing in Preview is also an option, but less optimal since I'll certainly need to adjust some formatting and page breaks. Maybe on publisher? Is anything like this possible? Or do I need to do it page-by-page? What would you do? I'm on a Mac 10.8.2.
posted by RandlePatrickMcMurphy
on Nov 19, 2012 -
Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
posted by dg
on Sep 4, 2012 -
Hoping someone can help me sort this problem ...
It's a excel + microsoft word document + mail merge to outlook email to 50 people.
I am trying to help someone out - this is is as it just as it was described to me:
Track changes were accepted and turned off and the email looked as it should - so off went 50 customized emails.
..unfortunately the sent email then shows that all the emails are sent showing all of the tracked change revision markings!
Sorry if this is too vague. Thanks for your efforts :)
posted by anewnormal
on Nov 30, 2011 -
Can anyone recommend a good, well-trafficked forum for Microsoft Office (particularly 2010) questions? Seems like this should be eminently Googleable, but maybe because there are so many of them, I'm not finding the one that is the
posted by The Dutchman
on Mar 19, 2011 -
How can I create a web-based table of contents that links to specific places within a diverse collection of documents? [more inside]
posted by kirkaracha
on Mar 17, 2011 -
Microsoft Access 2007 - how on earth do I cut / copy / export / do anything
with my Pivot Chart, besides print it? [more inside]
posted by Jimbob
on Nov 23, 2010 -
Microsoft Office 2007 filter: Can you recommend a program/plugin (or the like) which will replace the "ribbon" interface with a traditional menu interface? Free is ideal, but for-pay is okay, too. Running Windows XP. Thanks.
posted by Conrad Cornelius o'Donald o'Dell
on Nov 7, 2010 -
I need help copying a table from Word to Excel in Office 2007. Where there are hard returns within a cell in the Word table, Excel splits the table cell into multiple rows. I need Excel not to split cells in the Word table into multiple Excel rows. At the same time, I need to retain the paragraphs that appear within the Word table cells - that is, I can't just get rid of all those hard returns; the formatting must be preserved. My Google-fu is failing me rather seriously. Is there any way to do this?
posted by Dasein
on Oct 18, 2010 -
Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them? [more inside]
posted by notcostello
on Jun 29, 2010 -
I'm trying to paste some text from Excel into Word. Normally when I do this, I select Paste Special > Unformatted Text so my stuff doesn't display as a table. But this time, the Excel text is already formatted with a ton of bold, italics, and underlining, and I don't know how to retain that formatting while still ditching the table. Help? [more inside]
posted by anderjen
on Jun 10, 2010 -
Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel? [more inside]
posted by randomname25
on May 19, 2010 -
Can you reccomend me a good Excel 2007 Book?
I'm currently studying a foundation degree in Renwable Energy in the UK, and am struggling with Excel 2007. A general book would be handy, but the main topic I'm really struggling with is 'visual basic', so it would need to include detailed information on how to use that and the coding system of Excel.
Can anyone reccomend a good book to get that would include information relative to that?
posted by sockpim
on May 5, 2010 -
How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]
posted by jujube
on Dec 17, 2009 -
I'm looking for a job doing presentation graphics (in law firms, possibly financial firms); this is about 30% of my current job at a law firm. I'm one of very few "experts" at my firm which isn't very technologically advanced in this area, so I'm afraid that my skills won't cut it in the outside world. I need advice on how to upgrade my skills. [more inside]
posted by kenzi23
on Sep 30, 2009 -
Does anyone know how to remove the formatting (for lack of better expression) column borders
that accompany text when I paste it from Excel to Word?
I've checked both Word & Excel help to no avail, probably because I can't frame the question very well.
posted by holdenjordahl
on Sep 9, 2009 -
Is it possible for an email attachment in Outlook to 'update' itself from a network drive? My attachment is not the same now as it was when I first received and viewed it. [more inside]
posted by youngergirl44
on Jul 7, 2009 -
I need to make a template for an in-print events calendar, and I'm not sure what the best way to approach this project is. Advice please! [more inside]
posted by soviet sleepover
on May 5, 2009 -
My main computer is a Mac (iBook) and I use the Address Book and Apple Mail. I also manage the email list for a group, and I need to be able to export the list of email addresses to either Excel (preferably) or Word. I haven't figured out how to do that. [more inside]
posted by bibbit
on Apr 13, 2009 -
Has anyone taken the Office Proficiency Assessment and Certification (OPAC) test recently, or have documentation on what exactly
it tests for in Word and Excel? [more inside]
posted by limeswirltart
on Mar 6, 2009 -
I need MS Excel and Word to play together nicely. I can do what I need to in Word, and I can do what I need to in Excel; it's the Relationship that's Complicated. Maybe I need workflow advice? Basic knowledge? Please, please keep reading. [more inside]
posted by cheeken
on Feb 5, 2009 -
Automation Filter: How can I automate the insertion of data from a spreadsheet into a Word report template? [more inside]
posted by McBearclaw
on Jan 6, 2009 -
Help me create custom documents out of pre-written paragraphs in Word. [more inside]
posted by bove
on Dec 7, 2007 -
The management at the company I'm working for has sold a couple customers on a product that we as the worker-bees have yet to produce. That being said I view this more as an opportunity to do something new than as a huge hassle, assuming we can figure out a convenient way of producing said product. So I was hoping the great and wonderful MeFi might have a couple suggestions they might throw my way. [more inside]
posted by bernsno
on Sep 17, 2007 -
How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc
. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
posted by bokinney
on Mar 12, 2007 -
I'm doing a code review and I'm keeping track of my findngs on an Excel spreadsheet. I need to generate reports that show vital details about the source code file being reviewed. Unfortunatley, as far as I can tell, MS Word 2003 generates one Word doc that has all oft he merged content in one file. How do I get it to create separate documents? [more inside]
posted by apark
on Nov 17, 2006 -
My girlfriend is going for an interview where she will be tested on Microsoft Word and Excel. Is there an online tutorial where she can take some sample tests or run through some applications? We've googled a few, but they seem to stop at beginner levels and to be rather cumbersome. Just wondered if anyone had some first hand knowledge of a site to head to.
posted by patrickje
on Nov 16, 2006 -
A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file. [more inside]
posted by empyrean
on Jun 6, 2006 -
I need some computer work done for me and I'm not sure how to find someone to do it. [more inside]
posted by ikkyu2
on Mar 6, 2006 -
Is there a quick way to create a mail merge directory in Word from an Excel spreadsheet, broken down by a specific field (department, category, etc.)? This seems like a Microsoft 101 question, but the built-in Help doesn't seem to address this specifically, and online help
from Word 2002 gets into code I can't even begin to understand. [more inside]
posted by pzarquon
on Sep 7, 2005 -
I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand. [more inside]
posted by michaelkuznet
on Sep 1, 2005 -
When I try running long complex macros in MS Word for OS X, created in Office for Mac OS 9.2, some of the macros are freezing/crashing. Perhaps even worse, the macros don't seem to be failing at the same point each time I try to run them. [more inside]
posted by ParisParamus
on Jun 15, 2005 -
I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this. [more inside]
posted by synecdoche
on May 4, 2005 -
Is there a way to cut'n'paste charts from Excel into Word, without generating huge Word files? I've tried varieties of paste, 'paste special,' and so on, and I can't figure out why an Excel file of charts that's several hundred KB, always turns into a Word file that's at least several MB. I guess I'm missing something obvious, but have no idea what it is.
posted by carter
on Jun 24, 2004 -