Author Topic: Mail merge from Excel to Microsoft Word  (Read 463 times)

Offline usernane

  • Dansdeals Silver Elite
  • **
  • Join Date: Feb 2016
  • Posts: 79
  • Total likes: 8
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: usa
Mail merge from Excel to Microsoft Word
« on: October 25, 2020, 01:07:03 AM »
I'm having an issue when merging addresses from Excel to Microsoft Word. A zip codes that starts with the number 0 will not show up on the mail merge. For example of 08701 will show up as 8701.
In the Excel sheet I tried to right-click the table and click on zip code but it did not help me

Offline Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1252
  • Total likes: 224
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Mail merge from Excel to Microsoft Word
« Reply #1 on: October 25, 2020, 02:34:05 AM »
I'm having an issue when merging addresses from Excel to Microsoft Word. A zip codes that starts with the number 0 will not show up on the mail merge. For example of 08701 will show up as 8701.
In the Excel sheet I tried to right-click the table and click on zip code but it did not help me
I know this is really old and you found a solution.

I had the same issue recently this fixed it for me


Offline yg99

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Nov 2010
  • Posts: 409
  • Total likes: 5
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Mail merge from Excel to Microsoft Word
« Reply #2 on: October 25, 2020, 09:39:24 AM »
Change the data type for that column to general or text and not number.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12008
  • Total likes: 2058
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Mail merge from Excel to Microsoft Word
« Reply #3 on: October 25, 2020, 09:54:16 AM »
Or put an apostrophe before the zip code (in excel) to force it to format as text
Workflowy. You won't know what you're missing until you try it.

Online aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12274
  • Total likes: 6744
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Mail merge from Excel to Microsoft Word
« Reply #4 on: October 25, 2020, 11:54:13 AM »
Or put an apostrophe before the zip code (in excel) to force it to format as text
Not if you are pasting
Feelings don't care about your facts

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12008
  • Total likes: 2058
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Mail merge from Excel to Microsoft Word
« Reply #5 on: October 25, 2020, 12:01:52 PM »
Not if you are pasting
Then you could sort, add a formula column that concats apostrophe with the value in the column, copy and paste values back to the original column.
Or format it as text and hope it doesn't get switched back but in my experiences sometimes it does and then you have to re-add all the zeroes
Workflowy. You won't know what you're missing until you try it.

Online aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12274
  • Total likes: 6744
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Mail merge from Excel to Microsoft Word
« Reply #6 on: October 25, 2020, 02:51:14 PM »
Then you could sort, add a formula column that concats apostrophe with the value in the column, copy and paste values back to the original column.
Or format it as text and hope it doesn't get switched back but in my experiences sometimes it does and then you have to re-add all the zeroes
Format as text before pasting and paste values
Feelings don't care about your facts

Offline jose34

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2016
  • Posts: 1857
  • Total likes: 84
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Mail merge from Excel to Microsoft Word
« Reply #7 on: May 12, 2021, 10:23:44 AM »
Feel to post somewhere else but after using Mail Merge a website that will split the document for you to individual documents is:
 https://products.aspose.app/words/splitter