Computing.Net > Forums > Office Software > Using Excel Database for Mail Merge

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

Using Excel Database for Mail Merge

Reply to Message Icon

Name: AuntyJean
Date: November 18, 2007 at 03:03:51 Pacific
OS: Win XPSP2
CPU/Ram: IntelĀ® PentiumĀ® 4 Proce
Product: Dell Dimension 5150
Comment:

I have created a simple letter and use Excel as the data source.

When I merge the document on my PC at home it creates the correct number of letters to correspond with the number of records

However, when I use the exact same templates on the computer in work, it creates an additional 30 or so blank letters! I have tried deleting columns and rows in case there is a rogue character somewhere but it still does this.

Any ideas why?



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: November 18, 2007 at 08:52:05 Pacific
Reply:

Are the versions the same? Have you tried just entering the data in a real database (Access) and creating your letters that way?

Life's more painless for the brainless.


0

Response Number 2
Name: DerbyDad03
Date: November 18, 2007 at 11:24:26 Pacific
Reply:

When you say "blank letters" do you mean templates with your text but without addresses or blank sheets, period? If they are blank, are they mixed in with the "real" letters or all at the end?

I ask because I'm wondering if the Print Set-up is different because of a different printer and causing each letter to create a blank page due to a larger margin puching a line feed or two to another page. I see that in docs I receive at work.

If that's not it...

I'm not sure if this will help, but it might tell us something: When you get to the step where you can edit the recipient list, click the link and see if there are more items in the list than your actual list, such as blank lines with check marks.


0
Reply to Message Icon

Related Posts

See More


Outlook Ex. won't display... Outlook 2000 personal fol...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Using Excel Database for Mail Merge

Mail Merge Not Working www.computing.net/answers/office/mail-merge-not-working/6110.html

Mail-merging DBF files into MS Word www.computing.net/answers/office/mailmerging-dbf-files-into-ms-word/3555.html

Excel/Word Mail Merge www.computing.net/answers/office/excelword-mail-merge/8414.html