Is mail merge formatting done in excel?

jawa912

New Member
Joined
Apr 13, 2016
Messages
15
I'm working on a mail merge from excel. On some pages, the data comes over and is mostly spaced evenly but on other pages is spaced all over. Is there a way to get all the spacing to be consistent on each page so it doesn't look so sloppy?

I've tried to put the merge fields into a table, but when there isn't any data on the additional lines there is a huge wasted space where the empty lines from the table are.

Should i be formatting something on the excel spreadsheet to stop this from happening?

The OMPACTO is whats jumping all around.
1091 EDWIN GARCIA O M P C T O
4434 LOURDES MENDEZ O M P C T O

​I can't figure out how to attach the file of screenshots sorry
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Mailmerge output formatting is handled entirely in Word. Your description suggests you have an issue with unsuitable paragraph formatting in Word.
 
Upvote 0

Forum statistics

Threads
1,214,584
Messages
6,120,387
Members
448,957
Latest member
Hat4Life

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top