[Solved] OpenOffice Mail Merge

Discuss the spreadsheet application

[Solved] OpenOffice Mail Merge

Postby Odd.acious » Tue May 07, 2019 12:03 am

Hello everyone! Okay, I have a several step problem. My issue is that I am trying to create a mail merge for letters and labels. I believe I am stuck on getting the Spreadsheet formatting correct. How can I merge two columns all the way down the page?
For example, how may I merge one column with street numbers and a column with street names into one column? I have about 100 addresses to combine.
Last edited by Hagar Delest on Tue May 14, 2019 7:51 am, edited 1 time in total.
Reason: tagged solved
OpenOffice 3.1 Windows 10
Odd.acious
 
Posts: 2
Joined: Mon May 06, 2019 11:58 pm

Re: Open Office Mail Merge

Postby FJCC » Tue May 07, 2019 12:55 am

You can merge the text of two cells with
Code: Select all   Expand viewCollapse view
=A1 & B1

You probably want a space between the two, so use
Code: Select all   Expand viewCollapse view
=A1 & " " & B1

You can copy and paste the formula into the other cells in the column.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7229
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Open Office Mail Merge

Postby Odd.acious » Tue May 07, 2019 8:16 pm

That worked very well to combine the first two columns! How do I do this, besides putting that formula into each column, apply that to the entire spreadsheet?
OpenOffice 3.1 Windows 10
Odd.acious
 
Posts: 2
Joined: Mon May 06, 2019 11:58 pm

Re: Open Office Mail Merge

Postby RoryOF » Tue May 07, 2019 8:23 pm

The Help file says
If you want to copy a formula into multiple cells, there is a quick and easy way to copy into adjacent cell areas:
1. Select the cell containing the formula.
2. Position the mouse on the bottom right of the highlighted border of the cell, and continue holding down the mouse button until the pointer changes to a cross-hair symbol.
3. With the mouse button pressed, drag it down or to the right over all the cells into which you want to copy the formula.
4. When you release the mouse button, the formula will be copied into the cells and automatically adjusted.
If you do not want values and texts to be automatically adjusted, then hold down the Ctrl key when dragging. Formulas, however, are always adjusted accordingly.
Related Topics
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29285
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Calc

Who is online

Users browsing this forum: Google [Bot], unclebirt and 24 guests