mail merge from excel

V

Vass

i want to mail merge from excel

but the addresses sit in colum A
each address is listed in its entirity add1, add2, city, county, postcode
all separated by commas
so
first contact sits in A1
second in A2
etc.

Can I mail merge from this or do i need to move the address into col's
B,C,D,E etc ?
then mail merge ?

thanks
 
J

Jim Rech

I don't know how you are going to do the mail merge (there being no mail
merge utility in Excel as far as I know) but if you do need to parse the
data use the Data, Text To Columns command. Specify delimited data and the
comma as the delimiter.

--
Jim Rech
Excel MVP
|i want to mail merge from excel
|
| but the addresses sit in colum A
| each address is listed in its entirity add1, add2, city, county, postcode
| all separated by commas
| so
| first contact sits in A1
| second in A2
| etc.
|
| Can I mail merge from this or do i need to move the address into col's
| B,C,D,E etc ?
| then mail merge ?
|
| thanks
|
| --
| Vass
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MAIL MERGE FROM EXCEL 1
Mail Merge from excel to pdf files 2
How do I do a "mail merge" from excel to excel? 1
mail merging in Excel 1
Mail Merge from Word 2
Excel to Mail Merge 3
excel mail merge 2
Excel 2007 - combining worksheets to use for a mail merge 1

Top