Is mail merge formatting done in excel?

jawa912

New Member
Joined
Apr 13, 2016
Messages
11
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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,567
Mailmerge output formatting is handled entirely in Word. Your description suggests you have an issue with unsuitable paragraph formatting in Word.
 

Forum statistics

Threads
1,136,328
Messages
5,675,136
Members
419,551
Latest member
thangxpm

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
Top