[mso] Re: Word 2000 merge
- From: "Peggy Church" <peggychurch@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 6 Sep 2007 14:48:39 -0400
I open Word and retrieve my formatted envelope.
I click on Tools, down arrow, mail merge and options. When I click on
create, my envelope doc is listed. Next I click get data and open data
source. I click on the exel file with the data and I get a small screen
asking if entire spreadsheet or filter database. I choose entire
spreadsheet. Now my excel data file name is listed. AND the merge button is
gray.
There is some other route I took and it asked for which sheet, and I said
sheet1, which also led me to a gray merge button.
Thanks for helping me with this.
Peggy
----- Original Message -----
From: "Dian D. Chapman" <dian@xxxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Wednesday, September 05, 2007 11:51 PM
Subject: [mso] Re: Word 2000 merge
> Sorry, don't know what to tell ya cos' it works fine for me when I go
> through the steps in Word 2000.
>
> Maybe you can document your steps, exactly, so we can reproduce them as
> you
> are doing to see if you're missing something???
>
>
> Dian D. Chapman
> Technical Consultant, Microsoft MVP
> MOS Certified Instructor, Editor/TechTrax Ezine
> https://mvp.support.microsoft.com/profile/Dian.Chapman
>
> Free PC Tutorials: http://www.mousetrax.com/techtrax
> Free Word Tricks eBook: http://www.mousetrax.com/books.html
> Optimize your business docs: http://www.mousetrax.com/consulting
> Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
>
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
> Of Peggy Church
> Sent: Wednesday, September 05, 2007 6:04 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: Word 2000 merge
>
> I wrote: I wish to use and existing envelope design and merge with an
> excel
>
> file of
>> names and addresses. My merge box shows each file correctly, but the
>> merge
>> button is grayed. What am I doing wrong?
>> *************************************************************
>
> The merge fields are already in the envelope design. I've even tried
> redoing them "for the program" but still a gray merge button.
>
> Peggy
>
>
> ----- Original Message -----
> From: "Dian D. Chapman" <dian@xxxxxxxxxxxxx>
> To: <mso@xxxxxxxxxxxxx>
> Sent: Wednesday, September 05, 2007 1:30 AM
> Subject: [mso] Re: Word 2000 merge
>
>
>> Have you inserted Merge Fields into the master envelope? If you haven't
>> inserted the fields you want, in the locations you want in the master
>> envelope, you can't merge it yet. Do that and your button will become
>> active.
>>
>> See the bottom of this article. There you'll see how the merge fields are
>> inserted. This is for labels, you'll only need to insert them into the
>> one,
>> master envelope.
>>
>> Make Your Own Holiday Labels
>> http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=126
>>
>> Hope this helps...
>>
>>
>> Dian D. Chapman
>> Technical Consultant, Microsoft MVP
>> MOS Certified Instructor, Editor/TechTrax Ezine
>> https://mvp.support.microsoft.com/profile/Dian.Chapman
>>
>> Free PC Tutorials: http://www.mousetrax.com/techtrax
>> Free Word Tricks eBook: http://www.mousetrax.com/books.html
>> Optimize your business docs: http://www.mousetrax.com/consulting
>> Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
>>
>>
>> -----Original Message-----
>> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
>> Behalf
>> Of Peggy Church
>> Sent: Tuesday, September 04, 2007 10:50 AM
>> To: mso@xxxxxxxxxxxxx
>> Subject: [mso] Word 2000 merge
>>
>> I wish to use and existing envelope design and merge with an excel file
>> of
>> names and addresses. My merge box shows each file correctly, but the
>> merge
>> button is grayed. What am I doing wrong?
>> *************************************************************
>> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
>> or
>> MicrosoftOffice@xxxxxxxxxxxxxxxx
>>
>> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>>
>> To Unsubscribe from this group, visit the group's homepage and use the
>> dropdown menu at the top. This will allow you to unsubscribe your email
>> address or change your email settings to digest or vacation (no mail).
>> //www.freelists.org/webpage/mso
>>
>> To be able to share files with the group, you must join our Yahoo sister
>> group. This group will not allow for posting of emails, but will allow
>> you
>> to join and share problem files, templates, etc.:
>> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>> FILE
>> SHARING ONLY.
>>
>> If you are using Outlook and you see a lot of unnecessary code in your
>> email
>> messages, read these instructions that explain why and how to fix it:
>> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> *************************************************************
>>
>>
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG.
>> Version: 7.5.448 / Virus Database: 269.13.5/988 - Release Date: 9/4/2007
>> 9:14 AM
>>
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG.
>> Version: 7.5.448 / Virus Database: 269.13.5/988 - Release Date: 9/4/2007
>> 9:14 AM
>>
>>
>> --
>> No virus found in this outgoing message.
>> Checked by AVG.
>> Version: 7.5.448 / Virus Database: 269.13.5/988 - Release Date: 9/4/2007
>> 9:14 AM
>>
>>
>> *************************************************************
>> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
>> or
>
>> MicrosoftOffice@xxxxxxxxxxxxxxxx
>>
>> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>>
>> To Unsubscribe from this group, visit the group's homepage and use the
>> dropdown menu at the top. This will allow you to unsubscribe your email
>> address or change your email settings to digest or vacation (no mail).
>> //www.freelists.org/webpage/mso
>>
>> To be able to share files with the group, you must join our Yahoo sister
>> group. This group will not allow for posting of emails, but will allow
>> you to join and share problem files, templates, etc.:
>> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>> FILE SHARING ONLY.
>>
>> If you are using Outlook and you see a lot of unnecessary code in your
>> email messages, read these instructions that explain why and how to fix
>> it:
>> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> *************************************************************
>>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top. This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister
> group. This group will not allow for posting of emails, but will allow
> you
> to join and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE
> SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email
> messages, read these instructions that explain why and how to fix it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.448 / Virus Database: 269.13.5/990 - Release Date: 9/4/2007
> 10:36 PM
>
>
> --
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.448 / Virus Database: 269.13.5/990 - Release Date: 9/4/2007
> 10:36 PM
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.448 / Virus Database: 269.13.5/990 - Release Date: 9/4/2007
> 10:36 PM
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top. This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister
> group. This group will not allow for posting of emails, but will allow
> you to join and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
