[Solved] Writing over image in a business card

[dogluvver22]

I want to print a business size card using an Avery template.
Every card will have the same full size image (covering all of the card)
Each card will have a different name printed on it.
The name will be drawn from either a Calc or Base source using Mail Merge.
Is this achievable?

I know I can print the name OK but having problems printing name on top of image/

[MrProgrammer]

Hi, and welcome to the forum.

Every card will have the same full size image (covering all of the card). Each card will have a different name printed on it. The name will be drawn from either a Calc or Base source using Mail Merge.

Use File → New → Labels (not Business Card). In the Labels dialog on the Labels subsection select the brand and business card type but don't select any database fields. In the Format subsection note the label's width and height. In the Options subsection select Entire Page and Synchronize, then use the New Document button.

In the new document at upper left insert a frame. In subsection Type set the correct width and height, unchecking Autosize. Select horizontal position Left and anchor To Paragraph. In subsection Wrap set the spacing to 0. In subsection Background set your image as the graphic. You probably want Type=Area.

Use View → Data Sources and select your database and table/query then drag the desired field headings down into the frame, formatting as desired. Unselect View → Data Sources. In the frame, position the cursor after the last database field. Use Insert → Fields → Other → Database → Next record → {YourDatabase} → {YourTable/Query} → Insert, then close the dialog. View → Field names should show the Next Record field.

Click Synchronize Labels. Use View → Data Sources. Select the records you want to merge with your document then use the Data To Fields icon. You're now ready to save or print your business cards. Read about Mail Merge in Help → Index or in User Guides (PDF) or searching for topics about it in the Writer Forum.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.