How do I set up mail merge using excel as my data source document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Louise - 29 Jan 2008 06:44 GMT

Hi. I am having trouble using mail merge. I wish to use excel as my data
source document however when I get to the "select recipients" stage excel is
not there and when I click "Browse" I don't seem to be able to find excel. Am
I doing something wrong or is there an easier way to do this. I am using
Windows XP. Any help on this issue is much appreciated. Cheers.

Reply to this Message

Doug Robbins - Word MVP - 29 Jan 2008 10:13 GMT

It is not actually Excel that you should be looking for, but the spreadsheet
(.xls file) that you created in Excel to be the source of the data for the
mail merge.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi. I am having trouble using mail merge. I wish to use excel as my data
> source document however when I get to the "select recipients" stage excel
[quoted text clipped - 3 lines]
> I doing something wrong or is there an easier way to do this. I am using
> Windows XP. Any help on this issue is much appreciated. Cheers.

Reply to this Message

sal - 30 Jan 2008 11:22 GMT

when you click on browse, you will get a window saying "select data sources"
now click the down arrow in "my data sources" and find the folder, desktop,
or my documents or any other folder that contains the excel sheet. when you
find the required excel sheet, click on it.

> Hi. I am having trouble using mail merge. I wish to use excel as my data
> source document however when I get to the "select recipients" stage excel is
> not there and when I click "Browse" I don't seem to be able to find excel. Am
> I doing something wrong or is there an easier way to do this. I am using
> Windows XP. Any help on this issue is much appreciated. Cheers.

Reply to this Message