CheckEmoji Community · the emoji forum
🏠 Home 🆕 What's new ❓ Unanswered 🔥 Popular 📡 RSS Members 👥 0 online log in · register
Home › IT › Software › Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...)

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...)

Started by Sophia Newman6 · · 👁 89 views · 1.6K replies

📡 Subscribe to replies

Participants Sophia Newman6Mark ReedDrew Hall3silverfox91hiddennomad13Kimberly Miller6Drew GarciaGeorge Nguyen3Walter Jackson48Kyle Johnson2neongull3slyhound32Benjamin Wilson7Edward Foster23northerncanyon16boldwalker2ruggedpanther2rustyranger12Jesse Williams14Hannah BarnesTerry Hayes2Robin White7driftingbear98Brenda Turner94 …
cosmicbison19 cosmicbison19 Member
26 messages
joined Mar 2011
#741 ·
Thanks.

I suppose it might be worth looking into using MERGEFIELD alongside INCLUDEPICTURE, as that could potentially prove useful for what you're trying to achieve.

Kyle Johnson2 said:I suppose you might be able to handle that through... So, I was thinking about how much easier things used to be before everything became so overly complicated, and it got me wondering about using Mail Merge within Word 2007. It’s one of those features that feels like it should be straightforward, yet sometimes you find yourself staring at the screen, wondering if you've missed a step or if the software is just being difficult, I suppose. If you're trying to get a mass mailing set up, you'll want to make sure your data source is ready to go—maybe an Excel spreadsheet with all your contact info neatly organized—before you even touch the Mail Merge settings. Once you have that, you can start linking the documents together. You'll be looking for those specific MERGEFIELD placeholders to tell Word exactly where to drop in the names or addresses. It’s a bit of a process, and I guess if you aren't careful, things can get messy, but once you get the hang of the flow between the data and the document, it usually settles down. It’s funny how much time we spend just trying to get the formatting to look right, isn't it? Anyway, if anyone has run into specific hiccups with the 2007 version, I'd love to hear how you handled them. I suppose I should probably get around to addressing this, though I can't quite decide if it's worth the effort or if I'm just overthinking things again. Maybe I am. It seems like there might be two ways to look at this, or perhaps it's just an "either/or" situation that I haven't fully unpacked yet. Either way, I guess we'll see how it unfolds. I suppose I was thinking about Word 2003 the other day, which feels like a lifetime ago, though I guess time does tend to slip away like that. It’s funny how much we rely on these older versions sometimes, even when everything else has moved on so rapidly..
There is one rather significant distinction to be made here, which really comes down to the specific way you go about using... I suppose I should probably get around to discussing the intersection of MERGEFIELD and the INCLUDEPICTURE field, though I suspect it’s one of those niche technical hurdles that most people just stumble over without much fanfare. It isn't exactly straightforward, is it? If you’re trying to pull dynamic images into a document via a Mail Merge, you might find that things don't always behave quite as predictably as one would hope, especially when you're deep in the weeds of Word 2007 or even older versions like Word 2003. The general idea, if I’m grasping it correctly, involves using the MERGEFIELD to point toward a file path, which then feeds into the INCLUDEPICTURE command. However, there is this rather finicky little quirk where the images don't always refresh themselves automatically after the merge is complete. You often find yourself having to manually trigger an update—perhaps by selecting everything and hitting a specific key combination—just to get the visuals to actually show up where they belong. It feels a bit clunky, I guess, almost as if the software expects you to hold its hand through the entire process. It’s a bit of a dance, really, navigating the syntax to ensure the pathing is correct so that the engine knows exactly which JPEG or PNG to grab from your local drive or server. One small typo in that string of code and, well, you're left staring at a blank space where a headshot or a logo ought to be. I suppose you’re asking about what exactly needs to be entered manually using the Ctrl + F9 shortcut, though I imagine you might already have a bit of an idea. If I had to guess, you're probably looking to wrap those specific fields in curly braces, since that’s how you trigger the field codes within Word, isn't it? It feels a bit archaic sometimes, almost like we're stepping back into the era of Word 2003, but I guess that's just how the software expects us to behave if we want things to work properly.
Kenneth Gray67 Kenneth Gray67 Newcomer
1 message
joined Jun 2009
#742 ·
Hey everyone. I’ve got some work piled up on my desk, but somehow I’ve managed to lose access to Word on my computer. I can't seem to find a reliable download anywhere, so if anyone has a link for a one-time use version, I could really use the help. It's a bit of a mess right now. 😁 Feel free to shoot me a DM.
driftingnomad68 driftingnomad68 Member
18 messages
joined Sep 2005
#743 ·
Kenneth Gray67 Kenneth Gray67 Newcomer
1 message
joined Jun 2009
#744 ·
driftingnomad68 said:http://www.libreoffice.org/download 😬

It isn't Word, but it gets the job done. Thanks! 🤣
driftingangler11 driftingangler11 Newcomer
1 message
joined Sep 2011
#745 ·
Kyle Johnson2 said:No, I didn't forget. I was actually thinking you should upload that file to a server somewhere—maybe something like: Check out http://www.filesonic.com/. Or something like that—just drop the download link here once you have it.

Ah, I saw the word "here" in bold and just assumed it was supposed to be a pointer. 🙂

Here we go. I can't see any link here. Please provide the URL so I can take a look. To the file. 🙂
I think something strange is happening with it—it’s almost like it’s running an update with a one-step delay or something similar.
Frank Scott3 Frank Scott3 Newcomer
1 message
joined May 2011
#746 ·
Does anyone know how to tweak Excel 2007 so it stops displaying zeros when they're the result of a calculation? I remember in older versions, you could just head over to Tools / Options / window options and uncheck the box for zero values to hide them, and everything worked perfectly. For some reason, I can't seem to track down that specific setting in this version. Any chance someone could point me in the right direction?
Thanks so much in advance!
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#747 ·
driftingangler11 said:I think something weird is going on with it—

First off, you clearly didn't read this post properly:
You copied the Macro into a Module when it was supposed to go into ThisWorkbook (it's clearly stated right there in the post)

Second, that problematic source file you uploaded creates a backup with an *.XLK extension because it was originally made in "Microsoft Office 2008"—specifically using the "Excel 2008 rev. 489" part of the suite—so on top of everything else, it’s spitting out an extra XLK backup file in the same folder as the original.
That's why my file worked fine. Next time, actually read the instructions. 😉
later
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#748 ·
Frank Scott3 said:How do I set up Excel 2007 so it doesn't show a zero when a cell calculates to nothing?

Hit the Office button => Excel Options => Advanced => then just uncheck "Show a zero in cells that have zero value."
driftingangler11 driftingangler11 Newcomer
1 message
joined Sep 2011
#749 ·
Kyle Johnson2 said:First off, you clearly didn't read the instructions in this post properly:
You pasted the Macro into a Module when it actually needs to go into ThisWorkbook (as explicitly stated in the post).

Secondly, that problematic original file you uploaded creates a backup with an *.XLK extension because it was originally created using "Microsoft Office 2008"—specifically within the "Excel 2008" component of that suite. Because of that, it generates an additional backup file in the XLK format right in the same folder as the original.
That's why my file worked perfectly fine. Next time, please read carefully. 😉
Best regards,

First—I did read it, I just obviously didn't grasp what you were getting at. I don't really understand the difference between a "module" and "ThisWorkbook." I just followed the steps from that explanatory post you mentioned: I hit ALT+F11 and pasted the text inside. 😢

As for the original file, it was made using either Office 2000 or Excel 2003. It’s possible a colleague worked on it later and saved it in a different format, but I personally built it in Excel about five or six years ago.

It shouldn't matter, but could you please explain this module vs. ThisWorkbook thing so I can try applying it to the original file? 😁

EDIT—I think I finally figured out the module/ThisWorkbook distinction. 😍
boldcrane6 boldcrane6 Member
13 messages
joined Nov 2013
#750 ·
Hey there! 🙂

Does anyone know how I can get Word to automatically capitalize the first letter of every sentence? I think it would save me a bit of a headache—kind of hoping it just does itself!
Nicholas King Nicholas King Regular
716 messages
joined Jan 2023
#751 ·
boldcrane6 said:Hi there! 🙂

How do I get Word to automatically capitalize the first letter of every sentence?

Honestly, don't even bother mentioning which version of Word you're using—it's probably not going to matter much anyway. 🙂

If you happen to be stuck using Word 2003, you can find it under Autocorrect Options -> Tools -> Autocorrect Options, then just check the box for "Capitalize first letter of sentences."
boldcrane6 boldcrane6 Member
13 messages
joined Nov 2013
#752 ·
Nicholas King said:Seriously, don't you dare let on which version of Word you're actually using. 🙂

In Word 2003, you just head over to Autocorrect Options -> Tools -> Autocorrect Options and check the box for "Capitalize first letter of sentences."

😍

Thanks! 🙂
Kate Williams Kate Williams Newcomer
2 messages
joined Feb 2011
#753 ·
Greetings to everyone! I was wondering if anyone might be able to assist me with summing up values from multiple Sheets into one single, separate Sheet.
Basically, when I am working with just two Sheets, everything works perfectly fine, such as this formula:
=SUM(January:February!B14),

However, for some reason, it simply refuses to cooperate when I try to include three or more Sheets—do I need to group them somehow first?

My ultimate goal is to get a formula functioning like this: =SUM(January:April!B14), which would effectively sum up the value in cell B14 across all those months into one consolidated Sheet.
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#754 ·
Gregory Rogers20 said:Hey everyone, anyone know how to sum up values from multiple Sheets into one master Sheet?

If you're trying to pull all the values from cell B14 across several Sheets, just grab one of these formulas:
Code:
=January!B14+February!B14+March!B14+April!B14
=SUM(January!B14,February!B14,March!B14,April!B14)
=SUM(January:April!B14)
nimblebadger9 nimblebadger9 Newcomer
2 messages
joined May 2011
#755 ·
I’m asking for a favor here. I am a complete novice when it comes to this stuff, but I see some real experts hanging around here, so I figured I’d post in the existing thread rather than cluttering things up with a new topic. Does anyone know how to actually clear my history on Google Chrome? Every single thing I try fails miserably. Thanks in advance.
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#756 ·
nimblebadger9 said:How do I clear my history on Google Chrome?

What does that have to do with Microsoft Office?
Check out these links, might help you out
- LINK1
- LINK2
nimblebadger9 nimblebadger9 Newcomer
2 messages
joined May 2011
#757 ·
Kyle Johnson2 said:What on earth does any of this have to do with Microsoft Office?
Take a look at these links, maybe they'll actually be useful to you
- LINK1
- LINK2

I realize there isn't a connection, but I assumed you people would know better, and clearly, I was wrong. Thanks. It worked.
Charles Ramos7 Charles Ramos7 Regular
529 messages
joined Jul 2010
#758 ·
I've got a PHP booking form on my site that sends all the details straight to my email. Is there any way to link those incoming entries to Excel so they automatically list out and sort themselves chronologically?
ruggedmaker2 ruggedmaker2 Regular
469 messages
joined Mar 2018
#759 ·
Can someone give me a hand here? 🙂
Every time I try to print certain Word documents, the printer just sits there staring at me. It won't actually start printing until I physically walk over and mash the start button.
I've been trying to wrap my head around why this only happens with specific files, but honestly, I haven't cracked the code yet. 😁
Is this some hardware issue—maybe a driver headache?—or is it something about how the document itself is built?
Not sure if it matters, but I'm still running Microsoft Office 2000 on this old rig.
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#760 ·
ruggedmaker2 said:I could definitely use a hand here too 🙂
...........Is this a printer issue (maybe drivers?) or just how the document is set up?

Could be anything at this point 😉
Check HERE

You must log in or register to reply here.

Log in Register

🔗 Similar threads