Author Topic: Mail Merge Help  (Read 538 times)

Offline gubevo18

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2014
  • Posts: 1081
  • Total likes: 96
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: here
Mail Merge Help
« on: March 27, 2024, 03:54:34 PM »
Trying to create about 65 of the same form document. Successful imported the date from Excel to word. Now trying to save them individually using the invisible heading outlook vie create documents method but two issues are coming up and I can't figure out why.

1. The font of the of all the text in the document changes when saved as an individual document.

2. A blank page shows up at the end of each document.

Appreciate any tips or advice. I spent a while googling before posting but nothing fixed it. TIA

Offline Jojo202

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Jun 2020
  • Posts: 630
  • Total likes: 218
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Brooklyn, NY
Re: Mail Merge Help
« Reply #1 on: March 27, 2024, 04:15:10 PM »

Offline gubevo18

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2014
  • Posts: 1081
  • Total likes: 96
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: here
Re: Mail Merge Help
« Reply #2 on: March 27, 2024, 04:58:55 PM »

Offline Definitions2

  • Dansdeals Gold Elite
  • ***
  • Join Date: Aug 2023
  • Posts: 223
  • Total likes: 159
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Mail Merge Help
« Reply #3 on: March 27, 2024, 06:40:30 PM »
Can you print to PDF and then use a PDF splitter afterwards?

Offline Jojo202

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Jun 2020
  • Posts: 630
  • Total likes: 218
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Brooklyn, NY
Re: Mail Merge Help
« Reply #4 on: March 27, 2024, 07:28:10 PM »
Can you print to PDF and then use a PDF splitter afterwards?
If you are doing that, PDFsam is a great program for that.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12921
  • Total likes: 3383
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Mail Merge Help
« Reply #5 on: March 27, 2024, 07:51:23 PM »
If you are doing that, PDFsam is a great program for that.
100%
Workflowy. You won't know what you're missing until you try it.

Offline SHL

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2023
  • Posts: 542
  • Total likes: 113
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Israel
Re: Mail Merge Help
« Reply #6 on: March 27, 2024, 11:18:44 PM »
If you are doing that, PDFsam is a great program for that.
Is the formfiller free?

Offline gubevo18

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2014
  • Posts: 1081
  • Total likes: 96
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: here
Re: Mail Merge Help
« Reply #7 on: March 28, 2024, 01:38:05 AM »
If you are doing that, PDFsam is a great program for that.
appreciate it but can't download external apps or software on work computer.

Offline Definitions2

  • Dansdeals Gold Elite
  • ***
  • Join Date: Aug 2023
  • Posts: 223
  • Total likes: 159
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Mail Merge Help
« Reply #8 on: March 28, 2024, 04:13:31 PM »
appreciate it but can't download external apps or software on work computer.
I think there are online websites that can do it. Never done it before so don't know the trustworthiness or if your dealing with sensitive data

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12921
  • Total likes: 3383
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Mail Merge Help
« Reply #9 on: March 28, 2024, 04:16:27 PM »
I think there are online websites that can do it. Never done it before so don't know the trustworthiness or if your dealing with sensitive data
If you absolutely can't, you can export one page at a time from word to pdf using the Options button after clicking Create PDF / XPS.

But I would first turn on Show/Hide both in the template and in the merged documents to see if there's an extra page break. And as far as the font, you can right click and toggle field codes (there's also a keyboard shortcut) and add or take out MERGEFORMAT. I've had the font problem before and some fussing and googling usually fixed it.
« Last Edit: March 28, 2024, 04:20:54 PM by etech0 »
Workflowy. You won't know what you're missing until you try it.