Mail merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our mailing contacts were saved in Cardbox (!!!!!!!!) and I have moved them
into an Excel spreadsheet. However, all the address components (street, city,
postcode) were in one field. Is there any easy way (I am an idiot) to
separate these companents into different Excel fields before I produce a mail
merge from the spreadsheet?
 
I've already tried that but it doesn't work because some addresses may have 4
words, others many more which means that, for example, the city may appear in
column 4 or any column after that so not all corresponding elements of the
address are in the same column. But thanks.
 
Are the addresses separated by commas? For example 1236 3rd Street, Mytown,
mystate, zip? If so use text to columns, delmited, uncheck tab and check
comma.
 

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

Hep with Find and Replace 16
using images in a mail merge 2
Mail Merge & Excel 2
Importing from Excel - multiple street fields 2
Using separate fields in address makes gaps in labels? 1
Mail Merge without using Word 3
mail merge from excel 3
Excel Word Mail Merge 8

Back
Top