| Extract all emails | |
Posted: Sat Jan 31, 2009 8:41 am |
Points: 0 |
|
petrovlis |
GoldMine Journeyman |
|
|
Joined: 31 Jan 2009 |
Posts: 33 |
Location: Netherlands |
|
|
|
|
|
|
|
I need to make/export a list of ALL primary and secondary emails in
GMPE
What filter ?
In Goldmine itself or via Goldbox which I have also
Thanks
William |
|
|
|
|
Posted: Sat Jan 31, 2009 9:04 am |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
When you say "primary and secondary emails", do you really mean E-mail Addresses, or are you talking about actual E-mails? |
|
_________________ Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| Extract email adr. | |
Posted: Sat Jan 31, 2009 9:15 am |
Points: 0 |
|
petrovlis |
GoldMine Journeyman |
|
|
Joined: 31 Jan 2009 |
Posts: 33 |
Location: Netherlands |
|
|
|
|
|
|
|
BobTaylor wrote: |
When you say "primary and secondary emails", do you really mean E-mail Addresses, or are you talking about actual E-mails? |
Yes I mean email addresses like xxxxxxxx@yyyyyyy.com
Thanks
William |
|
|
|
|
| | |
Posted: Sat Jan 31, 2009 9:53 am |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
If all you want is a raw list of all the E-mail Addresses that you currently have, for all Contacts, then a simple query would do that:
Code: |
Select (Contsupref+Address1) as EmailAddr from Contsupp where RecType='P' and Contact='E-mail Address' |
You may or may not want to add the Accountno and/or E-mail Merge Codes to your Select statement. You could run that right in GoldMine, and export it to Excel. However, there are other things that you might want to do, and that's where GoldBox 7 could come into play.
1. Dedupe - if you may have multiple instances of the same Address and want to remove the dupes, GoldBox 7 would help with that. I'd run the same query as above, but run it using a GoldBox 7 Convert to dBase setup. That will give you a named, saved dBase file that you can then dedupe using GoldBox 7.
2. If you have ever imported E-mail Addresses using GoldBox (or any other utility program), you might well have multiple instances of a Primary Address for the same Accountno...the same Address or different Addresses. (Or, conversely, Contacts who have E-mail Addresses, but none of which are Primary...even GoldMine allows you to create that situation). These are not good things, and until now, the procedures required to correct them were lengthy and troublesome. However, there is development going on right now with GoldBox that will (I hope) greatly improve that situation. Can't be more specific now, but it shouldn't be long.
So, it really depends on what you want. If you want E-mail Addresses plus fields from the Main Contact, a GoldBox 7 Export from Contsupp can give you that. Given all these options, if you know exactly what you want now, come back and specify it, and I'll see if I can provide more specific guidance. |
|
_________________ Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
| Extract Email address | |
Posted: Sat Jan 31, 2009 11:25 am |
Points: 0 |
|
petrovlis |
GoldMine Journeyman |
|
|
Joined: 31 Jan 2009 |
Posts: 33 |
Location: Netherlands |
|
|
|
|
|
|
|
Thank you very very much, I knew " Oh Yes, You Can" but finding out myself is taking
me too much time.
I did with the Select .. you gave and exported to Excel.
Thank you again !!!!!
William |
|
|
|
|
Posted: Sat Jan 31, 2009 11:42 am |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
|
_________________ Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|