Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition) » Output to Excel - Email Address Issue
Post new topic  Reply to topic View previous topic :: View next topic 
Output to Excel - Email Address Issue
PostPosted: Mon Oct 01, 2012 1:28 pm Points: 1 Reply with quote
TPorter2
Awesome Administrator
Joined: 30 Jun 2006
Posts: 334
Location: Addison, TX




I am posting this resolution just in case it helps anybody else.

Was running a SQL Query for email addresses entered in the last month and then outputting the results to Excel.

Excel showed the first two rows of results and then skipped about 50 rows. Tried lots of different fixes with no success. Finally went to the email address in the row where the problem started. Someone had entered a name in quote marks and enclosed parenthesis marks inside of that. I stripped that out and the output to Excel worked fine.

To be accurate, Excel didn't skip rows, it just clumped all of the data from the 50 rows in one row. Anyway, problem solved!
View user's profile Send private message

Output to Excel - Email Address Issue
  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  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin