#1
|
|||
|
|||
Auto populating labels w/out mail merge
Hi all, banging my head on something simple, I think.
I have a co-worker that uses 7x9 label sheets (63 total labels) to print stickers for an upcoming inventory. She manually enters in dates for all the labels (all 63 labels are identical dates). I created a quick mail merge for her that auto-populates the labels with a date but I think it might be too complicated for her to maintain/change the date, etc. I was trying to think of a way to have the labels auto populate using something simple like a header or a watermark, but those work at the document level and not individually at the cell/label level. Is there a simple solution to this where she doesn't have to Ctrl-C and then Ctrl-V 62 times? Thanks for any advice! |
#2
|
|||
|
|||
Mail merge is the simple method.
BTW, Watermarks are images in the header and work at the page/section (not document) level. It is fairly simple to create a set of dates in an Excel column and do the merge. Show her how to do that and give her access to this page: Mail merge using an Excel spreadsheet - Word |
#3
|
|||
|
|||
I think if you copy and paste across all the labels in one row, then select that row and paste onto all the remaining rows, you have way fewer than 62 copy/pastes to do.
I just tried this with Avery 5162, a two-across, seven-down grid with a small spacer column between the two labels. Worked fine. Copying the row copied the blank in the middle column. If I'd highlighted the first sell then pasted onto the entire sheet, I'd have to clean out that middle column. Ann |
#4
|
||||
|
||||
If the workbook is properly configured, the user should only have to change the date in one cell - the rest of the dates should just reference that cell. No idea what your 'etc.' refers to, though.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
If your co-worker is using a template for the labels then you can add a date picker content control to each of the cells in the template via Insert | Quick Parts | Document Property | Publish Date. Then all she needs to do is select a date in one and all the others will update automatically.
|
#6
|
|||
|
|||
Mailings\Create\Labels...
Select "Full page of the Same label" Enter desired Text Once. Alternate. Use a Template Document (so the lable size is already set) with dummy text and then show Find and Replace on how to replace the dummy text with the desired text for all instances. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Populating multiple Content Controls after mail merge | guiltyvictim | Word VBA | 3 | 07-30-2019 09:27 AM |
Populating Tables with data when available only - Using Mail merge | stevejohhnym | Mail Merge | 1 | 06-25-2019 12:50 AM |
Mail Merge Field Not Populating | JennEx | Mail Merge | 3 | 05-10-2015 09:30 PM |
Help with a mail merge onto labels | dhause211 | Mail Merge | 1 | 07-14-2014 09:36 PM |
Labels Mail Merge | borislibman | Outlook | 0 | 12-13-2009 07:23 PM |