I need to print address labels for a mailing and want to print my business's return address on the same label as my recipient's address.
I have a spreadsheet I'm using as the recipient list. I found a thread that I couldn't respond to (too old?), but the answer didn't help me or apparently the folks that replied either. In any event, how do you do this? I am using a 2x4 label where I want my return address and logo, then the recipients address. I can create the plain mail merge labels easily, but I can't get my return address to print on them all. When I follow the instructions in the aforementioned thread, I get only one label per page, multiple pages. If I use the mail merge wizard, it fills the page with the different recips (what I want, which is 10 labels/sheet), but I can't get a return address on there. We are small business people who are reasonably computer savvy and want to look professional on the relatively rare occasions that we're doing this, but end up killing WAY too much time trying to get it done. Please lay out step-by-step instructions for doing this. I have been at this job now for almost an hour, and I could have entered the data manually and been done by now.
My alternative is to print 2 sets of labels. One with my return address and one with the mail merge labels, but that defeats the purpose. Please help!