Author Topic: microsoft word-excel- office (Read 143469 times)

elit · « **Reply #300 on:** March 17, 2015, 01:27:40 PM »

Quote from: etech0 on March 17, 2015, 12:35:42 PM

Is there any way to run a word mailmerge off of a google spreadsheet? (ie: instead of an excel file)

Why wouldn't you just download it to excel?

etech0 · « **Reply #301 on:** March 17, 2015, 01:33:11 PM »

Quote from: elit on March 17, 2015, 01:27:40 PM

Why wouldn't you just download it to excel?

Because I'm doing it a few times a week, based on data that someone puts into a google spreadsheet.
Until now I've been downloading, but I was curious if there's a better way.

elit · « **Reply #302 on:** March 17, 2015, 02:00:03 PM »

Quote from: etech0 on March 17, 2015, 01:33:11 PM

Because I'm doing it a few times a week, based on data that someone puts into a google spreadsheet.
Until now I've been downloading, but I was curious if there's a better way.

Ok i hear.... If you find a way i would like to hear it...

good sam · « **Reply #303 on:** March 17, 2015, 06:00:02 PM »

Love the feeling of figuring out how to work around a stubborn Microsoft Word quirk.

For years I could not figure out why my documents sometimes leave a huge space at the bottom of the page, not allowing me to backspace the paragraph beginning on the following page, even when there is no page or section break.

Today I learned about Widow/Orphan Control, which prevents any part of a paragraph from (r"l) getting separated from the rest of the paragraph. Check this setting off and...wala (though now I feel a little sad for the few lines that were orphaned $:-\$ )

an613 · « **Reply #304 on:** March 17, 2015, 06:10:24 PM »

Quote from: etech0 on March 17, 2015, 12:35:42 PM

Is there any way to run a word mailmerge off of a google spreadsheet? (ie: instead of an excel file)

What do you use for email? If it's gmail then you can.

etech0 · « **Reply #305 on:** March 17, 2015, 06:23:41 PM »

Quote from: an613 on March 17, 2015, 06:10:24 PM

What do you use for email? If it's gmail then you can.

I use gmail. How would that help with a mailmerge that I'm printing out?

an613 · « **Reply #306 on:** March 17, 2015, 06:26:31 PM »

Quote from: etech0 on March 17, 2015, 06:23:41 PM

I use gmail. How would that help with a mailmerge that I'm printing out?

O sorry, I thought you were emailing it

Live N Learn · « **Reply #307 on:** June 16, 2015, 05:06:07 AM »

Quote from: good sam on March 17, 2015, 06:00:02 PM

Love the feeling of figuring out how to work around a stubborn Microsoft Word quirk.

For years I could not figure out why my documents sometimes leave a huge space at the bottom of the page, not allowing me to backspace the paragraph beginning on the following page, even when there is no page or section break.

Today I learned about Widow/Orphan Control, which prevents any part of a paragraph from (r"l) getting separated from the rest of the paragraph. Check this setting off and...wala (though now I feel a little sad for the few lines that were orphaned $:-\$ )

Where do you find that option?

Live N Learn · « **Reply #308 on:** June 30, 2015, 06:18:12 AM »

Quote from: User6669 on June 16, 2015, 05:06:07 AM

Where do you find that option?

Bump.

Copernicus · « **Reply #309 on:** June 30, 2015, 06:40:17 AM »

@User6669 See here: http://word.tips.net/T001149_Controlling_Widows_and_Orphans.html

elit · « **Reply #310 on:** June 30, 2015, 04:01:00 PM »

Is there a way to have excel sort a list of addresses or zip codes by distance b to a specific location or zip?

lubaby · « **Reply #311 on:** June 30, 2015, 04:41:03 PM »

Quote from: elit on June 30, 2015, 04:01:00 PM

Is there a way to have excel sort a list of addresses or zip codes by distance b to a specific location or zip?

Read through this, should do the trick.

elit · « **Reply #312 on:** June 30, 2015, 06:04:57 PM »

Quote from: lubaby on June 30, 2015, 04:41:03 PM

Read through this, should do the trick.

Thanks but looks way over my head

Live N Learn · « **Reply #313 on:** June 30, 2015, 06:27:04 PM »

Quote from: Copernicus on June 30, 2015, 06:40:17 AM

@User6669 See here: http://word.tips.net/T001149_Controlling_Widows_and_Orphans.html

Thanks.

etech0 · « **Reply #314 on:** July 01, 2015, 12:33:37 PM »

Cool!

http://www.howtogeek.com/218982/how-to-create-a-new-item-in-outlook-directly-from-the-clipboard/

Pressing control-v while in outlook will create a new mail item with whatever was in the clipboard.

noturbizniss · « **Reply #315 on:** July 01, 2015, 01:08:00 PM »

Quote from: etech0 on July 01, 2015, 12:33:37 PM

Cool!

http://www.howtogeek.com/218982/how-to-create-a-new-item-in-outlook-directly-from-the-clipboard/

Pressing control-v while in outlook will create a new mail item with whatever was in the clipboard.

Only that though - signature is not put in. PITA

etech0 · « **Reply #316 on:** July 01, 2015, 01:09:14 PM »

Quote from: noturbizniss on July 01, 2015, 01:08:00 PM

Only that though - signature is not put in. PITA

shoot.
just like when you are in word/excel and you do file > save and send

would be nice if there was a way around that

noturbizniss · « **Reply #317 on:** July 01, 2015, 01:10:29 PM »

Quote from: etech0 on July 01, 2015, 01:09:14 PM

shoot.
just like when you are in word/excel and you do file > save and send

would be nice if there was a way around that

Exactly. Except file > save and send is an even bigger PITA because if you need to go back and reference a tab or cell or look something up you can't. You have to close the mail item. It's a complete waste.

etech0 · « **Reply #318 on:** July 01, 2015, 01:43:14 PM »

Quote from: noturbizniss on July 01, 2015, 01:10:29 PM

Exactly. Except file > save and send is an even bigger PITA because if you need to go back and reference a tab or cell or look something up you can't. You have to close the mail item. It's a complete waste.

Plus you can't look at anything else in outlook until you close/send the mail item.

etech0 · « **Reply #319 on:** August 10, 2015, 03:08:21 PM »

I have a document that contains a "pretend" table, made by tab stops. Is there any way to convert it to a regular table in Word so that I can copy it to excel?