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

Offline usernane

  • Dansdeals Silver Elite
  • **
  • Join Date: Feb 2016
  • Posts: 62
  • Total likes: 6
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: usa
Mail merge from Excel to Microsoft Word
« on: Yesterday at 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

Online Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1114
  • Total likes: 178
  • DansDeals.com Hat Tips 2
    • View Profile
    • LimitedLiquidations
Re: Mail merge from Excel to Microsoft Word
« Reply #1 on: Yesterday at 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

One of a kind deals - www.limitedliquidations.com

Offline yg99

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

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11434
  • Total likes: 1461
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Mail merge from Excel to Microsoft Word
« Reply #3 on: Yesterday at 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.

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 11036
  • Total likes: 4824
  • DansDeals.com Hat Tips 8
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Mail merge from Excel to Microsoft Word
« Reply #4 on: Yesterday at 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
Just because things turned out a certain way doesn't mean you were right.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11434
  • Total likes: 1461
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Mail merge from Excel to Microsoft Word
« Reply #5 on: Yesterday at 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.

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 11036
  • Total likes: 4824
  • DansDeals.com Hat Tips 8
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Mail merge from Excel to Microsoft Word
« Reply #6 on: Yesterday at 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
Just because things turned out a certain way doesn't mean you were right.