RE: Problems with converting data held in an Excel spreadsheet to Word

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: mark Gray (markGray_at_discussions.microsoft.com)
Date: 07/05/04 

Date: Mon, 5 Jul 2004 02:08:01 -0700

Cindy M
Apologies for not enough information before. Heres a full explanation of the problem:-

I collect a lot of data in excel, including field headings such as Title, Initials, Surname, Address line 1, Address line 2 ........ Scheme, Annual Amount .. etc..
This data is extracted from a separate application.

I then filter the data (using auto filter), so I say only get members of scheme 1 not scheme 2 and 3.

I then copy and paste this data to a new word document, where I format the Name and Address field columns (singularly rather than in bulk) so that all alpha fields are 'title case' sensitive.

I then try and do a mail merge in word to this data, and get the word error messages about missing cell data (ie one record may not have an entry in address line 4, but others do), and also I get all schemes, rather than just scheme 1, and also the reformatting to 'title case' is reverted back to the original case.

I could link to the original data in Excel, but then again have problems with reformatting the data, and with the selection process.

I think that is about all.

Your assistance would be most welcome.

Regards 

-- 
Mark
"mark Gray" wrote:
> I am using MS Office 2000 Professional, and have a lot of mail merge documents where I have all the required data in an Excel spread***.  I then try and complete mail merges on a selection of the data.
> 
> I then copy and paste the spread*** into a word document to reformat the data, and then complete the merge.
> 
> However, word ignores the reformatting, and the deselected data, and constantly brings up the warning 'too few data items'.
> 
> This causes the mail merge to fail.  As a fallback I use another PC with an earlier version of Office, and this procedure works perfectly, however this is time consuming and eventually these other PCs will be phased out.
> 
> Solutions to this problem would be very weelcome.
> 
> Thank you
> -- 
> Mark
Quantcast