Ask Your Question
0

unable to customize salutation on mail merge

asked 2018-08-03 15:48:07 +0200

islamicbookstore gravatar image

I would like to create a personalized salutation in my mail merge, and having a problem. In the Mail Merge Wizard, step 4 (Create Salutation), I successfully perform step 1 (drag salutation elements into the box). However, box 2 is greyed out, not allowing me to enter in a custom salutation. (In step 1, I dragged <first name="">. I want my custom salutation to simply be "Dear <first name="">." However, I cannot add the word "Dear" in Step 2, as it is greyed out."

Thanks for any help!!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2018-08-03 18:28:59 +0200

islamicbookstore gravatar image

Problem solved. I used David Burke's very informative blog page on Mail Merge in LibreOffice (https://davidmburke.com/2011/08/10/ma...)

In brief, the Step 4 in MailMerge should be completely disregarded, because it doesn't seem to work as intended. Instead, use the Edit/Exchange Database access/capability, and just drag the necessary fields you want to use into your document, and make your own salutation.

In Writer, Click Edit then Exchange Database… Then click Browse. Select the file you just made

On the left is a list of data sources. These should include the file you just made. Select it, then Tables, then Sheet1 (or the name of the sheet you want)

You will see the data from the spreadsheet. Click and drag the column you want into your document. For example if I wanted First Name, I would click and drag the First Name column title and not an individual cell like Bob. You will notice it appears gray in your document. You are free to cut and paste it or change the formatting. These words will be replaced with the data in your spreadsheet.

edit flag offensive delete link more
0

answered 2018-08-03 19:52:37 +0200

updated 2018-08-03 19:54:00 +0200

You need not only to drag an element, but also select the dragged element in the top box to make second drop-down list active. It works as intended, because you could have multiple customizable elements there, and the drop-down contents depends on the selection.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-03 15:48:07 +0200

Seen: 100 times

Last updated: Aug 03 '18