A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

mail merge, envelope addressing from excel database



 
 
Thread Tools Display Modes
  #1  
Old May 2nd, 2005, 01:19 AM
jej
external usenet poster
 
Posts: n/a
Default mail merge, envelope addressing from excel database

Trying to mail merge in Word for envelope addressing.
In Word, Tools, Letters&Mailing, Mail Merge. Mail Merge window pane appears
on right. Select "envelopes" as document type and then Next. Using Current
blank document. Problem arrises next, when "Selecting Recipients". I click
on browse and select my excel file. Then comes a "Select Table" dialog box.
I find the Sheet in the workbook that I want and select it. Then it takes me
to antother Select Table dialog box, only this one is empty. When I hit OK,
it says "Word was unable to open the data source". That is NOT what is
described in teh help files. Why wont it open my excel workbook and use
those addresses for these mail merge envelopes????
  #2  
Old May 2nd, 2005, 06:12 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default

See the Excel data section of
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jej wrote:
Trying to mail merge in Word for envelope addressing.
In Word, Tools, Letters&Mailing, Mail Merge. Mail Merge window pane
appears on right. Select "envelopes" as document type and then Next.
Using Current blank document. Problem arrises next, when "Selecting
Recipients". I click on browse and select my excel file. Then comes
a "Select Table" dialog box. I find the Sheet in the workbook that I
want and select it. Then it takes me to antother Select Table dialog
box, only this one is empty. When I hit OK, it says "Word was unable
to open the data source". That is NOT what is described in teh help
files. Why wont it open my excel workbook and use those addresses
for these mail merge envelopes????



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal points on an excel mail merge Wishart1 Mailmerge 1 November 12th, 2004 12:05 AM
Excel database to mail merge BobBlueJay General Discussion 3 September 7th, 2004 01:09 AM
Mail Merge with Excel David Cornwell Mailmerge 1 June 13th, 2004 10:57 PM
Not enough fields in Excel for mail merge document Dave Mailmerge 2 June 8th, 2004 04:28 PM
Mail Merge to excel spreadsheet problem Alex Mailmerge 1 May 25th, 2004 04:07 PM


All times are GMT +1. The time now is 09:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.