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

Offline elit

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2008
  • Posts: 1349
  • Total likes: 118
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: microsoft word-excel- office
« Reply #300 on: March 17, 2015, 01:27:40 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?

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #301 on: March 17, 2015, 01:33:11 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.
Workflowy. You won't know what you're missing until you try it.

Offline elit

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2008
  • Posts: 1349
  • Total likes: 118
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: microsoft word-excel- office
« Reply #302 on: March 17, 2015, 02:00:03 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...

Offline good sam

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2011
  • Posts: 3340
  • Total likes: 557
  • DansDeals.com Hat Tips 10
    • View Profile
Re: microsoft word-excel- office
« 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 :-\)
If you don't care why would you comment?
HT: DMYD

Offline an613

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Apr 2010
  • Posts: 319
  • Total likes: 2
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #304 on: March 17, 2015, 06:10:24 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.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #305 on: March 17, 2015, 06:23:41 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?
Workflowy. You won't know what you're missing until you try it.

Offline an613

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Apr 2010
  • Posts: 319
  • Total likes: 2
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #306 on: March 17, 2015, 06:26:31 PM »

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

O sorry, I thought you were emailing it

Offline Live N Learn

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2015
  • Posts: 3799
  • Total likes: 332
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
Re: microsoft word-excel- office
« Reply #307 on: June 16, 2015, 05:06:07 AM »
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?
".איזהו חכם, הלומד מכל אדם"

Offline Live N Learn

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2015
  • Posts: 3799
  • Total likes: 332
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
Re: microsoft word-excel- office
« Reply #308 on: June 30, 2015, 06:18:12 AM »
Where do you find that option?

Bump.
".איזהו חכם, הלומד מכל אדם"

Offline Copernicus

  • Dansdeals Silver Elite
  • **
  • Join Date: Jun 2015
  • Posts: 56
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: microsoft word-excel- office
« Reply #309 on: June 30, 2015, 06:40:17 AM »

Offline elit

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2008
  • Posts: 1349
  • Total likes: 118
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: microsoft word-excel- office
« 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?

Offline lubaby

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2010
  • Posts: 5335
  • Total likes: 736
  • DansDeals.com Hat Tips 12
    • View Profile
Re: microsoft word-excel- office
« Reply #311 on: June 30, 2015, 04:41:03 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.

Offline elit

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2008
  • Posts: 1349
  • Total likes: 118
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: microsoft word-excel- office
« Reply #312 on: June 30, 2015, 06:04:57 PM »
Read through this, should do the trick.
Thanks but looks way over my head

Offline Live N Learn

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2015
  • Posts: 3799
  • Total likes: 332
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
".איזהו חכם, הלומד מכל אדם"

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« 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.
Workflowy. You won't know what you're missing until you try it.

Offline noturbizniss

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2012
  • Posts: 7113
  • Total likes: 140
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
  • Location: North Jersey
Re: microsoft word-excel- office
« Reply #315 on: July 01, 2015, 01:08:00 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
READ THE DARN WIKI!!!!

Chuck Norris...
...can still do FT method
...READS THE WIKI!!!

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #316 on: July 01, 2015, 01:09:14 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
Workflowy. You won't know what you're missing until you try it.

Offline noturbizniss

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2012
  • Posts: 7113
  • Total likes: 140
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
  • Location: North Jersey
Re: microsoft word-excel- office
« Reply #317 on: July 01, 2015, 01:10:29 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.
READ THE DARN WIKI!!!!

Chuck Norris...
...can still do FT method
...READS THE WIKI!!!

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #318 on: July 01, 2015, 01:43:14 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.
Workflowy. You won't know what you're missing until you try it.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« 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?
Workflowy. You won't know what you're missing until you try it.