Merge fields then export

[Dave hole]

Hello,

I'm not sure if i am posting this to the right place so apologies now.

I have a CRM database in FM that i am trying to extract all the e-mail addresses from we have 10 fields defined "name" "E-mail" "Name2" "E-mail2" "Name3" "E-Mail3" etc up to five i have cteated a layout that shows only name and e-mail which i then export to excel to use in our e-campaign software. the problem is it creates diffrent columes in excel for each field when i only want 2 coloumes name and e-mail. Any help would be grate.

Thanks

Dave

[Lee Smith]

I'm not sure that I am understanding you correctly. I'm going to guess that your name field is more than one field, (i.e. First Name, Middle Initial, Last Name), and you want to combined them into one field. If so, you will need to create a new field, and use a calculation to Concatenate, and then use that as the export field to Excel along with your Email Field.

Whole_Name (Calculation, Text Result) +

First Name & Middle Name & Last Name

In your Export Dialog Box, select just the Whole_Name and Email Fields.

If this isn't what you want, let us know.

HTH

Lee

[Dave hole]

Maybe i didn't explain properly.

Name is only one field, when i export to excel it uses 10 coloums.

name|e-mail|name2|e-mail2|name3|e-mail3|

when i export i want to just make one list.

name 1,2,3,4,5|e-mail 1,2,3,4,5

to save me moving the data into two coloums manually.

[Lee Smith]

If you are only exporting these two fields, then you should be getting what you want.

Name        email

Name        email

Name        email

Name        email

Name        email

Name        email

What are you getting if not this?

Lee

[Dave hole]

There are 10 coloums that i want to murge into 2

name e-mail name2 e-mail2 name3 e-mail3

name e-mail name2 e-mail2 name3 e-mail3

name e-mail name2 e-mail2 name3 e-mail3

name e-mail name2 e-mail2 name3 e-mail3

name e-mail name2 e-mail2 name3 e-mail3

i want to make it

name e-mail

name e-mail

name e-mail

name e-mail

name e-mail

name e-mail

[Lee Smith]

post a copy of your file.

Lee

[LelandLong]

If I understand correctly, you have 10 fields & several records, when you should only have 2 fields & 5-times more records.

[we have 10 fields defined "name" "E-mail" "Name2" "E-mail2" "Name3" "E-Mail3" etc up to five]

(if you had 10 email addresses you would only have 2 records with 5-pairs of fields)

You need a new file that contains 2 fields: "Name" "E-mail".

To get your existing data into this new file, do several exports:

1) export just "Name1" "E-mail1" & import into new file

2) export just "Name2" "E-mail2" & import into new file

3) export just "Name3" "E-mail3" & import into new file

4) export just "Name4" "E-mail4" & import into new file

5) export just "Name5" "E-mail5" & import into new file

Now when you export your data (from the new file) to Excel you should have your desired 2-column format